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 areabout 10 fields in this database. Everytime I flush databases to load thelatest copy that I have uploaded and then try and do a search on them ittakes at least 10 minutes for WebCatalog to respond. None of the pages thatuse WebCatalog can be accessed during this time. Other static pages workfine though. Then after about 10 minutes things go back to normal and I canperform searches on that database and others without any problems.Is this normal behavior? I know this database will be growing to over150,000 items before we go public with it.Any help would be greatly appreciated.We are running:PowerMac G3 with 128MB of RAMMac OS X Server 1.02iTools 5.003 with WebCatalogKarim ArdalanMIS, 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:
Hi,We are developing a site that has a database of 50,000 items. There areabout 10 fields in this database. Everytime I flush databases to load thelatest copy that I have uploaded and then try and do a search on them ittakes at least 10 minutes for WebCatalog to respond. None of the pages thatuse WebCatalog can be accessed during this time. Other static pages workfine though. Then after about 10 minutes things go back to normal and I canperform searches on that database and others without any problems.Is this normal behavior? I know this database will be growing to over150,000 items before we go public with it.Any help would be greatly appreciated.We are running:PowerMac G3 with 128MB of RAMMac OS X Server 1.02iTools 5.003 with WebCatalogKarim ArdalanMIS, 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)