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:
Public beta 2 for WebCatalog 4.0 is now available. (2000)
no global [username] or [password] displayed ... (1997)
list items (1998)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
emailer setup (1997)
required fields (1998)
minimalist shopping cart. (1997)
taxTotal, grandTotal (1997)
Micro-managing External Links (2006)
Possible Bug in 2.0b15.acgi (1997)
WebCat2_Mac RETURNs in .db (1997)
os 8.5 (1999)
HomePage Caution (1997)
Online reference (1997)
Country & Ship-to address & other fields ? (1997)
ListFiles bug v3.0 OSX (2000)
Issue with plug-in Webcat, webstar 4.x, SSL and IE when using the backbuttom (2000)
[SearchString] problem with [search] context (1997)
What are SMSI's upgrade policies? (2003)
Exclamation point (1997)