Re: Webcat table size.
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37507
interpreted = N
texte = I'm not too worried about the size of the html file as i will limit the sizeof the file to fifty rows -> show next fifty , when i get around to it.on 31/7/01 9:36 AM, Andrew Simpson at andrew.simpson@trendsbooks.com wrote:> 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:
I'm not too worried about the size of the html file as i will limit the sizeof the file to fifty rows -> show next fifty , when i get around to it.on 31/7/01 9:36 AM, Andrew Simpson at andrew.simpson@trendsbooks.com wrote:> 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/
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:
Sense/Disallow HTML tags during $Append (1997)
Need help with emailer- 2 issues (1997)
Search and path arguments (1998)
Enhanced Master Counter? (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
ImageMagick on OSX (2003)
[isfolder] and [filename] (1997)
9 digit zip (2002)
WebCatalog/WebMerchant 2.1 (1998)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
WebDNA version? (2007)
Adding multiple items to Cart (1999)
Date to Daze (1999)
More on the email templates (1997)
[WebDNA] Show next..... (2010)
UPS Online (2004)
Emailer and encryption (1997)
Download Question (1997)
Works! (1997)
WC2b15 File Corruption (1997)