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 4856 Jul 19, 2001, 7:23 AM
Thread Re: Links SQL Building
Paul 4767 Jul 19, 2001, 8:10 AM
Thread Re: Links SQL Building
dan 4785 Jul 19, 2001, 8:32 AM
Thread Re: Links SQL Building
Alex 4772 Jul 19, 2001, 11:29 AM
Post Re: Links SQL Building
dan 4746 Jul 19, 2001, 1:02 PM
Thread Re: Links SQL Building
DogTags 4651 Aug 30, 2001, 6:42 AM
Thread Re: Links SQL Building
Paul 4662 Aug 30, 2001, 6:54 AM
Thread Re: Links SQL Building
DogTags 4639 Aug 30, 2001, 9:41 AM
Thread Re: Links SQL Building
Stealth 4658 Aug 30, 2001, 9:52 AM
Post Re: Links SQL Building
DogTags 4614 Aug 30, 2001, 10:30 AM
Thread Re: Links SQL Building
Paul 4623 Aug 30, 2001, 10:52 AM
Thread Re: Links SQL Building
DogTags 4623 Aug 31, 2001, 8:10 AM
Thread Re: Links SQL Building
Stealth 4637 Aug 31, 2001, 8:20 AM
Thread Re: Links SQL Building
Paul 4624 Aug 31, 2001, 9:53 AM
Thread Re: Links SQL Building
Stealth 4604 Aug 31, 2001, 11:02 AM
Post Re: Links SQL Building
DogTags 4586 Sep 2, 2001, 2:54 AM
Post Re: Links SQL Building
Alex 4611 Aug 31, 2001, 10:13 AM