Re: Size of File

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 66886
interpreted = N
texte = Nitai Performance will be governed a lot by the speed of your drives on =20 files of that size, also any anti-virus software running. Committing the db after each update will slow things down as it will =20 have to be re-read into ram on its next access. Have a look at not automatically committing the db in the prefs, =20 however for safety you will need to commit it on a regular basis =20 using a trigger etc. Stuart Tremain idfk web developments, sydney, australia On 20 Apr 2006, at 2:38 AM, Nitai @ ComputerOil wrote: > Hi all > > We have some problems with that the database has grown to a size of > 500MB and more and that the performance is slowly becoming a problem. > This is a server with 6GB of Ram and Linux. > > Anybody running databases in this size? If so please tell us how your > performance is and your machine data. I need to figure out if this =20 > is a > overall problem (I tested it on MacOS X, Windows and Linux) and =20 > they all > perform "ok" (though Windows is very slow). > > Nitai > > --=20 > eContentPark - Enterprise Digital Asset Management > eServices - The complete SupportSuite > eSurvey - Online Questionnaire made easy > Redakto CMS - Content Management that simply works > > ComputerOil=AE AG > Neugutstrasse 66 > 8600 D=FCbendorf / Switzerland > Telefon +41 (0)844 44 55 66 > > info@computeroil.com > http://computeroil.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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Size of File ( Stuart Tremain 2006)
  2. Size of File ( "Nitai @ ComputerOil" 2006)
Nitai Performance will be governed a lot by the speed of your drives on =20 files of that size, also any anti-virus software running. Committing the db after each update will slow things down as it will =20 have to be re-read into ram on its next access. Have a look at not automatically committing the db in the prefs, =20 however for safety you will need to commit it on a regular basis =20 using a trigger etc. Stuart Tremain idfk web developments, sydney, australia On 20 Apr 2006, at 2:38 AM, Nitai @ ComputerOil wrote: > Hi all > > We have some problems with that the database has grown to a size of > 500MB and more and that the performance is slowly becoming a problem. > This is a server with 6GB of Ram and Linux. > > Anybody running databases in this size? If so please tell us how your > performance is and your machine data. I need to figure out if this =20 > is a > overall problem (I tested it on MacOS X, Windows and Linux) and =20 > they all > perform "ok" (though Windows is very slow). > > Nitai > > --=20 > eContentPark - Enterprise Digital Asset Management > eServices - The complete SupportSuite > eSurvey - Online Questionnaire made easy > Redakto CMS - Content Management that simply works > > ComputerOil=AE AG > Neugutstrasse 66 > 8600 D=FCbendorf / Switzerland > Telefon +41 (0)844 44 55 66 > > info@computeroil.com > http://computeroil.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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.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://webdna.smithmicro.com/ Stuart Tremain

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:

Last freebie (1998) wild question (1998) [WebDNA] The phone home system is undesirable ... (2008) [WebDNA] Is WebDNA slowing things up - please try these URL's (2013) merchant accts. (1997) instant email reply (2001) WebMerchant - fixed, now trigger question... (1999) Whats going on with my SERIAL NUMBER??? (1998) Only charge card when product shipped ? (1997) Configuring E-mail (1997) Alias and MacOs X (2003) Question about links (1999) Date Calulation (1997) Resume Catalog ? (1997) WebCat2b13 Command Reference Doc error (1997) Extracting URL (2007) PCS Frames (1997) Re:Upload (1998) page chokes on hideif when false and ignored (1998) Cyberstudio and WebDNA (1997)