Re: Webcat table size.
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37504
interpreted = N
texte = >What kind of db table size (byte size) can be comfortably accomadated before >webcat/apache/webserver will start to complain or slow down ??? Huh?If you're asking about the size of a db, the answer depends on your hardware/software.If you're asking about html tables, the answer also depends on the network and client hardware/software.> >On a G4 433mhz, 512mb, 14gb partion. > >os:10.0.4, webcat:4.0.2-v2, itools:v6. > >Anybody have any idea's > >10mb table cause problems??? >50mb table >1gb... You need 1M of RAM per M of open database plus the OS/server software overhead.> >Is it cummlative - would ten small tables used as frequently as one big one >be just as slow??? > >The table/s are just used for appends. Is there something that can be done >to make tables be used more efficiently when you are not doing >lookups/searchs on them or is this kind of thing automatic ??? >If you want to get an open db out of memory, just use the close db function.Glenn------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>What kind of db table size (byte size) can be comfortably accomadated before >webcat/apache/webserver will start to complain or slow down ??? Huh?If you're asking about the size of a db, the answer depends on your hardware/software.If you're asking about html tables, the answer also depends on the network and client hardware/software.> >On a G4 433mhz, 512mb, 14gb partion. > >os:10.0.4, webcat:4.0.2-v2, itools:v6. > >Anybody have any idea's > >10mb table cause problems??? >50mb table >1gb... You need 1M of RAM per M of open database plus the OS/server software overhead.> >Is it cummlative - would ten small tables used as frequently as one big one >be just as slow??? > >The table/s are just used for appends. Is there something that can be done >to make tables be used more efficiently when you are not doing >lookups/searchs on them or is this kind of thing automatic ??? >If you want to get an open db out of memory, just use the close db function.Glenn------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Glenn Busbin
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:
Auto entering Friday's date in a field (2002)
View order not right (1997)
ListFiles (2000)
Next X hits (1996)
Execute Applescript (1997)
[WebDNA] [BULK] strange triggers.db occurrence??? (2012)
Carriage Returns on mail receipt (2002)
Search syntax question (1998)
Too Many Items found (2000)
Unexpected error (1997)
Make sure I understand this??? (1997)
WebCat2b15MacPlugin - showing [math] (1997)
[WebDNA] 64-bit Debian 6 with Lighttpd and WebDNA 7.1 (2012)
problem writing to db properly (2000)
orderfile problems osx (2003)
WebDNA 6.0 & MAC OS X Server 10.4.10 (2007)
Lookup Notfound (1998)
test (2004)
Reversed words (1997)
nesting limits? (1998)