Gossamer Forum
Home : Products : Gossamer Links : Pre Sales :

Re: Links SQL Building

Quote Reply
Re: Links SQL Building In reply to
In Reply To:
Do you think Links SQL could handle a million or more hits per day with that size db, tons of searches, and using page.cgi for lots of hits to the detail pages?
If you are on a dedicated server using mod_perl, it shouldn't be a problem...it would cause CPU problems if you are on a virtual server or semi-dedicated server.

In Reply To:
BTW, does each category get its own table, or are all cats in the same table? I'm just wondering how easy it would be to edit stuff off line - whether I would have to pull in a monster file to Excel, or whether each cat could be pulled in separately to make the job easier on my local computer.
All categories are located in ONE table, however, there is another table called CatLinks, which contains the LINKID from the LINKS table and CATEGORYID from CATEGORY table...have to get used to relational database, dogtags. Wink

Regards,

Eliot Lee Wink
http://anthrotech.com/
Subject Author Views Date
Thread Links SQL Building dan 5417 Jul 19, 2001, 7:23 AM
Thread Re: Links SQL Building
Paul 5316 Jul 19, 2001, 8:10 AM
Thread Re: Links SQL Building
dan 5333 Jul 19, 2001, 8:32 AM
Thread Re: Links SQL Building
Alex 5321 Jul 19, 2001, 11:29 AM
Post Re: Links SQL Building
dan 5294 Jul 19, 2001, 1:02 PM
Thread Re: Links SQL Building
DogTags 5200 Aug 30, 2001, 6:42 AM
Thread Re: Links SQL Building
Paul 5210 Aug 30, 2001, 6:54 AM
Thread Re: Links SQL Building
DogTags 5188 Aug 30, 2001, 9:41 AM
Thread Re: Links SQL Building
Stealth 5207 Aug 30, 2001, 9:52 AM
Post Re: Links SQL Building
DogTags 5163 Aug 30, 2001, 10:30 AM
Thread Re: Links SQL Building
Paul 5171 Aug 30, 2001, 10:52 AM
Thread Re: Links SQL Building
DogTags 5171 Aug 31, 2001, 8:10 AM
Thread Re: Links SQL Building
Stealth 5185 Aug 31, 2001, 8:20 AM
Thread Re: Links SQL Building
Paul 5172 Aug 31, 2001, 9:53 AM
Thread Re: Links SQL Building
Stealth 5152 Aug 31, 2001, 11:02 AM
Post Re: Links SQL Building
DogTags 5135 Sep 2, 2001, 2:54 AM
Post Re: Links SQL Building
Alex 5159 Aug 31, 2001, 10:13 AM