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'sof the site but it looks like if we keep on getting hits the way we are thetable 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 leastre-arrange the data to minimise the number of characters collected.lets the sales staff see stuff like this though which is quite neat.COUNTRY COUNTsg 893hk 254nz 11my 346au 2320nz 6434us 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:

Re: WebCat table size. (Christer Olsson 2001)
Re: WebCat table size. (Andrew Simpson 2001)
Re: WebCat table size. (Alain Russell 2001)
Re: Webcat table size. (Andrew Simpson 2001)
Re: Webcat table size. (Alain Russell 2001)
Re: Webcat table size. (Andrew Simpson 2001)
Re: Webcat table size. (Andrew Simpson 2001)
Re: Webcat table size. (Glenn Busbin 2001)
Re: Webcat table size. (Alain Russell 2001)
Webcat table size. (Andrew Simpson 2001)

Cheater!Well I have written this thing to record stats about hits on various area'sof the site but it looks like if we keep on getting hits the way we are thetable 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 leastre-arrange the data to minimise the number of characters collected.lets the sales staff see stuff like this though which is quite neat.COUNTRY COUNTsg 893hk 254nz 11my 346au 2320nz 6434us 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!

Re: Webcat table size.

2001

Top Articles:

Related Readings: