Re: Size of File
This WebDNA talk-list message is from 2006
It keeps the original formatting.
numero = 66886
interpreted = N
texte = NitaiPerformance will be governed a lot by the speed of your drives on =20files of that size, also any anti-virus software running.Committing the db after each update will slow things down as it will =20have to be re-read into ram on its next access.Have a look at not automatically committing the db in the prefs, =20however for safety you will need to commit it on a regular basis =20using a trigger etc.Stuart Tremainidfk web developments, sydney, australiaOn 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:
|
- Re: Size of File ( Stuart Tremain 2006)
- Size of File ( "Nitai @ ComputerOil" 2006)
|
NitaiPerformance will be governed a lot by the speed of your drives on =20files of that size, also any anti-virus software running.Committing the db after each update will slow things down as it will =20have to be re-read into ram on its next access.Have a look at not automatically committing the db in the prefs, =20however for safety you will need to commit it on a regular basis =20using a trigger etc.Stuart Tremainidfk web developments, sydney, australiaOn 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)