Re: WebCat table size.
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37516
interpreted = N
texte = That is not really that big, it will grow fast for a while and then the growth should top out as all the pages that can be accessed are loaded into the db. Are you only adding one entry per page and incrementing a value ?? Or adding a new entry for every access?Alain> 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/ > ------------------------------------------------------------- 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:
That is not really that big, it will grow fast for a while and then the growth should top out as all the pages that can be accessed are loaded into the db. Are you only adding one entry per page and incrementing a value ?? Or adding a new entry for every access?Alain> 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/ > ------------------------------------------------------------- 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:
Windows 2.1b2 Append Bug? (1997)
Some Advise needed (1997)
sendmail in html format? was allready solved..... (2002)
WebCat2b12plugin - [search] is broken ... not! (1997)
[WebDNA] Retrieving a PDF from an email (2008)
formatting a number (1999)
Not reading code (1997)
Webstar / WebCat - Persistent Setting (2003)
Re2: frames & carts (1997)
WebCatalog can't find database (1997)
RE: includes and cart numbers (1997)
RE: [WebDNA] DNA suffix (2008)
Encrypt/Decrypt (2007)
Webcat serving error page? (2000)
European Convention (2004)
Forcing a NEWCART (1997)
Calendar (1997)
Document Contains No Data! (1997)
WebCat2: Items xx to xx shown, etc. (1997)
Group search - using contexts (2000)