Performance, etc. (SOLVED)

Feb 5, 2013 at 7:54 PM
Have you ever ran any performance test when the database gets big?

Also, what is considered big in terms of number of objects, or database size(two seperate conditions)

I ask so that I can plan how to manage the database as it grows.
Feb 5, 2013 at 8:22 PM
Let me give you an example (NDatabase 3.4, release soon):

NDatabase.Performance.Tester with 1 as the argument gives
  • more than 1000000 objects
  • db size: about 173 MB (181,668,852 bytes)
  • time for creating db from scratch ~60s (on my machine - 2 cores, 6 gb ram, hdd disk)
  • querying without index for 1 object with 1 condition ~30s
You can play with that, with more sophisticated queries, indexes, more iteration of runs during creating (I created with a good time db with more than 5 GB, but on x64 system). All what you need you have in master branch, NDatabase.Performance.Tester project.

From time to time, it is good to use DefragmentTo operation to improve the size of db and to minimize fragmantation of db file.
Feb 6, 2013 at 6:35 PM
Thanks, I found the project!

Also, good info on DefragmentTo, I didn't know about that!