logo logo

 Back to main page

The NWNX Community Forum

 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Search found 4 matches
nwnx.org Forum Index
Author Message
  Topic: 2DA to MySQL migration yields 350+ avg improvement
Mithon

Replies: 9
Views: 13762
 PostForum: Database related   Posted: Sat Jan 19, 2008 19:01   Subject: 2DA to MySQL migration yields 350+ avg improvement
I'd also be very interrested in seeing those results.. I would love to know what the local vs db vs 2da lookup times on current versions of nwnx4 and nwn2 are.
  Topic: Performance: Direct DB or Local Caching?
Mithon

Replies: 6
Views: 9603
 PostForum: Database related   Posted: Fri Jun 22, 2007 3:23   Subject: Performance: Direct DB or Local Caching?
Agreed. Thanks for feedback.

I'll stick to what I'm doing then. Hmm.. might need to streamline the system by some more general calls and such maybe. Well.. thanks.
  Topic: Performance: Direct DB or Local Caching?
Mithon

Replies: 6
Views: 9603
 PostForum: Database related   Posted: Fri Jun 22, 2007 1:25   Subject: Performance: Direct DB or Local Caching?
Actually 60 calls every second. Note that the scenario I made was highly extreme and would likely never happen except for testing purposes.

Even so, the scenario was made to illustrate the problem. ...
  Topic: Performance: Direct DB or Local Caching?
Mithon

Replies: 6
Views: 9603
 PostForum: Database related   Posted: Thu Jun 21, 2007 0:35   Subject: Performance: Direct DB or Local Caching?
Primer: http://www.nwnx.org/phpBB2/viewtopic.php?t=17&postdays=0&postorder=asc&highlight=benchmark&start=0

Asmodae aptly points out that SQL is a disk-based system. It is robust, cr ...
 
Page 1 of 1
All times are GMT + 2 Hours
Jump to:  


Powered by phpBB © 2001, 2005 phpBB Group