Large database on Mac OS X Server

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27759
interpreted = N
texte = Hi, We are developing a site that has a database of 50,000 items. There are about 10 fields in this database. Everytime I flush databases to load the latest copy that I have uploaded and then try and do a search on them it takes at least 10 minutes for WebCatalog to respond. None of the pages that use WebCatalog can be accessed during this time. Other static pages work fine though. Then after about 10 minutes things go back to normal and I can perform searches on that database and others without any problems.Is this normal behavior? I know this database will be growing to over 150,000 items before we go public with it.Any help would be greatly appreciated.We are running: PowerMac G3 with 128MB of RAM Mac OS X Server 1.02 iTools 5.003 with WebCatalogKarim Ardalan MIS, Inc. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Large database on Mac OS X Server (Karim Ardalan 2000)
  2. Re: Large database on Mac OS X Server (Parker 2000)
  3. Large database on Mac OS X Server (Karim Ardalan 2000)
Hi, We are developing a site that has a database of 50,000 items. There are about 10 fields in this database. Everytime I flush databases to load the latest copy that I have uploaded and then try and do a search on them it takes at least 10 minutes for WebCatalog to respond. None of the pages that use WebCatalog can be accessed during this time. Other static pages work fine though. Then after about 10 minutes things go back to normal and I can perform searches on that database and others without any problems.Is this normal behavior? I know this database will be growing to over 150,000 items before we go public with it.Any help would be greatly appreciated.We are running: PowerMac G3 with 128MB of RAM Mac OS X Server 1.02 iTools 5.003 with WebCatalogKarim Ardalan MIS, Inc. ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Karim Ardalan

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

Search/sort in URL Was: GuestBook example (1997) Odd request (2003) Crazy dates (was: sorting dates) (1999) [WebDNA] WebDNA7 & Webmin (2013) Date search - yes or no (1997) Re:ListFields and [name] (1997) Re:2nd WebCatalog2 Feature Request (1996) searchable list archive (1997) Show new (2003) WebCat2 beta 11 - new prefs ... (1997) RE: .html to .tpl (1998) [thisurl] (2004) WebCatalog Hosting (1996) Unexpected error (1997) Rank=off, reverse direction (2004) Ok here is a question? (1997) SHOWIF/HIDEIF empty fields (2005) Date search bug (1998) Trouble with formula.db + more explanation (1997) headers (2004)