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 5018 Jul 19, 2001, 7:23 AM
Thread Re: Links SQL Building
Paul 4928 Jul 19, 2001, 8:10 AM
Thread Re: Links SQL Building
dan 4946 Jul 19, 2001, 8:32 AM
Thread Re: Links SQL Building
Alex 4933 Jul 19, 2001, 11:29 AM
Post Re: Links SQL Building
dan 4907 Jul 19, 2001, 1:02 PM
Thread Re: Links SQL Building
DogTags 4812 Aug 30, 2001, 6:42 AM
Thread Re: Links SQL Building
Paul 4823 Aug 30, 2001, 6:54 AM
Thread Re: Links SQL Building
DogTags 4800 Aug 30, 2001, 9:41 AM
Thread Re: Links SQL Building
Stealth 4819 Aug 30, 2001, 9:52 AM
Post Re: Links SQL Building
DogTags 4775 Aug 30, 2001, 10:30 AM
Thread Re: Links SQL Building
Paul 4784 Aug 30, 2001, 10:52 AM
Thread Re: Links SQL Building
DogTags 4784 Aug 31, 2001, 8:10 AM
Thread Re: Links SQL Building
Stealth 4798 Aug 31, 2001, 8:20 AM
Thread Re: Links SQL Building
Paul 4785 Aug 31, 2001, 9:53 AM
Thread Re: Links SQL Building
Stealth 4765 Aug 31, 2001, 11:02 AM
Post Re: Links SQL Building
DogTags 4747 Sep 2, 2001, 2:54 AM
Post Re: Links SQL Building
Alex 4772 Aug 31, 2001, 10:13 AM