Re: Webcat table size.
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37512
interpreted = N
texte = About 15000 rows and 3.9mb.on 31/7/01 10:02 AM, Alain Russell at alain.russell@blackpepper.co.nz wrote:> 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/-------------------------------------------------------------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:
About 15000 rows and 3.9mb.on 31/7/01 10:02 AM, Alain Russell at alain.russell@blackpepper.co.nz wrote:> 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/-------------------------------------------------------------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:
MacActivity and PCS (1997)
Subtotal and Grand Total Changes (2000)
Proper file locations (1997)
WebCat2b15MacPlugin - [protect] (1997)
vs (1997)
Request for page test (2003)
Sending mail (was forms and variables) (1998)
WebCat2 several catalogs? (1997)
upgrading (1997)
Resetting a Formvariable (2000)
two domains and one cart and database (2000)
Summing fields (1997)
searching for items that begin with a number (2004)
re:WebCatalog and Filemaker (1996)
New Business Opportunity (2006)
A dynamic database. (1997)
[WebDNA] how can i grab the contents of a post? (2011)
quit command on NT (1997)
Re:Virtual hosting and webcatNT (1997)
Erotic Sites (1997)