Re: Webcat table size.

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 37506
interpreted = N
texte = 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 4670page 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/ 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)
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 4670page 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/ Andrew Simpson

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:

Emailer setup (1997) security (1997) Can't Update records (1997) Editing two databases in one form using [replace]? (1998) Limiting user access to .tmpl files (1997) Setting up shop (1997) spell check site (2005) [sendmail] possible modification needed... (2000) [append] (1997) Attention all list readers (1997) format_to_days on NT (1997) [searchString] (1997) Bug? (1997) Newbie from and old bee (1997) WebCatalog Upgrade Pricing? (1997) Problem with [Search] inside of [Loop]? (1997) WebCat/PDF Integration Time Est (2000) Email Spam a bit of Hell (2004) I give up!! (1997) What date is it anyway? (2004)