Re: Webcat table size.

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37511
interpreted = N
texte = How big is the db now ?? You can see this in the WebCat admin pages. # of records etc.alain> Cheater! > > Well I have written this thing to record stats about hits on various area's > of the site but it looks like if we keep on getting hits the way we are the > table will out grow the machine in a matter of weeks. > > The sales people love it but it might fall over sooner rather than later. > > Might have to investigate some external database for it or at least > re-arrange the data to minimise the number of characters collected. > > lets the sales staff see stuff like this though which is quite neat. > > COUNTRY COUNT > sg 893 > hk 254 > nz 11 > my 346 > au 2320 > nz 6434 > us 4670 > > page views since firday night. > > and lots more. > > on 31/7/01 9:10 AM, Alain Russell at alain.russell@blackpepper.co.nz wrote: > >> Andrew, >> WebCat will process the data fine - mine load the server a bit for a while >> but it will get through it, the problem you will run into is the transfer of >> the info across the network. A 50MB HTML file will cause problems with IE >> when it comes down at it. >> >> How do you mean the tables are used for appends ?? Are you appending on >> every row in the table .. Can you explain this a bit more. >> >> Alain >> PS: the machine is a 500MHz G4 :-) >> >>> What kind of db table size (byte size) can be comfortably accomadated before >>> webcat/apache/webserver will start to complain or slow down ??? >>> >>> 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... >>> >>> 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 ??? >>> >>> >>> >>> Andrew Simpson. >>> >>> >>> ------------------------------------------------------------- >>> 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/ >>> >> >> >> ------------------------------------------------------------- >> 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/ > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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:

    
  1. Re: WebCat table size. (Christer Olsson 2001)
  2. Re: WebCat table size. (Andrew Simpson 2001)
  3. Re: WebCat table size. (Alain Russell 2001)
  4. Re: Webcat table size. (Andrew Simpson 2001)
  5. Re: Webcat table size. (Alain Russell 2001)
  6. Re: Webcat table size. (Andrew Simpson 2001)
  7. Re: Webcat table size. (Andrew Simpson 2001)
  8. Re: Webcat table size. (Glenn Busbin 2001)
  9. Re: Webcat table size. (Alain Russell 2001)
  10. Webcat table size. (Andrew Simpson 2001)
How big is the db now ?? You can see this in the WebCat admin pages. # of records etc.alain> Cheater! > > Well I have written this thing to record stats about hits on various area's > of the site but it looks like if we keep on getting hits the way we are the > table will out grow the machine in a matter of weeks. > > The sales people love it but it might fall over sooner rather than later. > > Might have to investigate some external database for it or at least > re-arrange the data to minimise the number of characters collected. > > lets the sales staff see stuff like this though which is quite neat. > > COUNTRY COUNT > sg 893 > hk 254 > nz 11 > my 346 > au 2320 > nz 6434 > us 4670 > > page views since firday night. > > and lots more. > > on 31/7/01 9:10 AM, Alain Russell at alain.russell@blackpepper.co.nz wrote: > >> Andrew, >> WebCat will process the data fine - mine load the server a bit for a while >> but it will get through it, the problem you will run into is the transfer of >> the info across the network. A 50MB HTML file will cause problems with IE >> when it comes down at it. >> >> How do you mean the tables are used for appends ?? Are you appending on >> every row in the table .. Can you explain this a bit more. >> >> Alain >> PS: the machine is a 500MHz G4 :-) >> >>> What kind of db table size (byte size) can be comfortably accomadated before >>> webcat/apache/webserver will start to complain or slow down ??? >>> >>> 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... >>> >>> 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 ??? >>> >>> >>> >>> Andrew Simpson. >>> >>> >>> ------------------------------------------------------------- >>> 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/ >>> >> >> >> ------------------------------------------------------------- >> 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/ > > > ------------------------------------------------------------- > 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/ > ------------------------------------------------------------- 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/ Alain Russell

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:

WebDNA-Talk Digests (1997) b12 cannot limit records returned and more. (1997) WARNING: MacOS The installer is broken... (2000) Max Record length restated as maybe bug (1997) problems with 2 tags shakur (1997) Searching Multiple DBs (1997) upgrading (1997) Proper file locations (1997) Grouping search fields, etc. (1997) question: webmerchant connection (1997) Variable Prices (1998) Attention all list readers (1997) RE: [WebDNA] Crashing (2008) Getting total number of items ordered (1997) WebCat2 Append problem (B14Macacgi) (1997) WebCat2b15MacPlugin - showing [math] (1997) PCS Customer submissions ? (1997) formula.db problems (1999) NewCart+Search with one click ? (1997) Order not created error (1997)