Hi Paul,
I'm giving your DB MyLinks a spin on my site and would like to say you've done a great job!
Although I have a quick query about the way links are stored. Can the LinkIDs of the stored listings be combined into one table which is then associated with the one UserID?
I just added three listings to MyLinks and had the username appear in the MyLinks table three times, with one link ID next to each username:
UserID | LinkID
test | 514
test | 562
test | 563
I'm currently using PortalLinks 2.0 (because I haven't released my Links SQL version until it's completely setup). I have 1,900+ registered users, with some users having as many as 300 - 400 stored links and I'm concerned my database will get bloated with duplicate UserID fields in the MyLinks table.
Is it possible to store the LinkIDs in the one field which is connected to the UserID? Eg:
UserID | LinkID
test | 514,562,563
anotheruser | 562,888,965,35
somebody | 563,335
Sorry, I can't get the text to line up. I've used a | to separate the fields.
Thanks in Advance,
Amanda
I'm giving your DB MyLinks a spin on my site and would like to say you've done a great job!
Although I have a quick query about the way links are stored. Can the LinkIDs of the stored listings be combined into one table which is then associated with the one UserID?
I just added three listings to MyLinks and had the username appear in the MyLinks table three times, with one link ID next to each username:
UserID | LinkID
test | 514
test | 562
test | 563
I'm currently using PortalLinks 2.0 (because I haven't released my Links SQL version until it's completely setup). I have 1,900+ registered users, with some users having as many as 300 - 400 stored links and I'm concerned my database will get bloated with duplicate UserID fields in the MyLinks table.
Is it possible to store the LinkIDs in the one field which is connected to the UserID? Eg:
UserID | LinkID
test | 514,562,563
anotheruser | 562,888,965,35
somebody | 563,335
Sorry, I can't get the text to line up. I've used a | to separate the fields.
Thanks in Advance,
Amanda