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

Links SQL Building

Quote Reply
Links SQL Building
I currently have the non-SQL version installed on a dedicated box (Pentium III-850, 256mb sdram). Nearly 11,000 sites and the links.db file is around 2.5 MB (no extra fields). Still purrs like a new born kitten (watch those claws) - kudos to GT. Searches continue to be blazing fast (albeit via specially modified search script), and no data corruption to date. But the one problem (the obvious one) is building (done via cron). Building is scheduled at midnight, daily. I just arose, and found that the server is still building. Ouch. Mind you, building occurs during non-peak traffic period - no obvious impact on server: pages serve fast and scripts (including search.cgi) execute relatively fast (during build, search for more common [max hits] keyword takes 4-7 seconds). But 7+ hours to build is getting silly. I have now disabled new submissions (and building the database) for the moment as I plan to upgrade to the Links SQL within the month.

For the database (and server) I describe, what sort of time frame would be typical (as a range for example) to cron build via Links SQL? And can you perform [Selective Build] if you use ratings (sites are sorted by rating alone)?


Cheers - Dan Cool


Subject Author Views Date
Thread Links SQL Building dan 5396 Jul 19, 2001, 7:23 AM
Thread Re: Links SQL Building
Paul 5295 Jul 19, 2001, 8:10 AM
Thread Re: Links SQL Building
dan 5313 Jul 19, 2001, 8:32 AM
Thread Re: Links SQL Building
Alex 5300 Jul 19, 2001, 11:29 AM
Post Re: Links SQL Building
dan 5274 Jul 19, 2001, 1:02 PM
Thread Re: Links SQL Building
DogTags 5179 Aug 30, 2001, 6:42 AM
Thread Re: Links SQL Building
Paul 5190 Aug 30, 2001, 6:54 AM
Thread Re: Links SQL Building
DogTags 5167 Aug 30, 2001, 9:41 AM
Thread Re: Links SQL Building
Stealth 5186 Aug 30, 2001, 9:52 AM
Post Re: Links SQL Building
DogTags 5142 Aug 30, 2001, 10:30 AM
Thread Re: Links SQL Building
Paul 5151 Aug 30, 2001, 10:52 AM
Thread Re: Links SQL Building
DogTags 5151 Aug 31, 2001, 8:10 AM
Thread Re: Links SQL Building
Stealth 5165 Aug 31, 2001, 8:20 AM
Thread Re: Links SQL Building
Paul 5152 Aug 31, 2001, 9:53 AM
Thread Re: Links SQL Building
Stealth 5132 Aug 31, 2001, 11:02 AM
Post Re: Links SQL Building
DogTags 5114 Sep 2, 2001, 2:54 AM
Post Re: Links SQL Building
Alex 5139 Aug 31, 2001, 10:13 AM