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:
Date as number and Cart partially explained (2001)
webten vs. webstar (1998)
Follow-up to listfiles bug report ... (2003)
apparently to problem isolated (1997)
FW: checkboxes (2000)
Webcat bannersleuth Qs (2001)
WebCatalog Technical Reference (1997)
Date Formats (1997)
Emailer problem (1998)
Searching Multiple DBs (1997)
Enhancement Request for WebCatalog-NT (1996)
Re:2nd WebCatalog2 Feature Request (1996)
showif/hideif 4.0 (2000)
page redirect in webDNA (1997)
Multiple cart additions (1997)
WebCat Error Log problem (2.0.1, acgi, Mac) (1997)
Mac: LModelDirector bug fix (1997)
WCf2 and nested tags (1997)
[OT] Robust order processing (2003)
Help name our technology! (1997)