sql db speed
Currently with 500+ folders, and 2000 ish rdp connections, the db is quite slow to edit. I am going to move sql to a better server but would like to know if there is anything to improve response, eg does encryption slow the use of sql based db.
All Comments (5)
Custom images and rtf description could slow down the load. Could you export the session to see the size of the content? You can also split it in multiple databases.
David Hervieux
Hi David,
Have you ever thought about an extented optimization for SQL.
Splitting some parts to seperate colums and tables could really improve the performants. What do you think?
Hi,
We plan to separate that in the next major update. The problem is the offline mode. You won't be able to access this information if you don't have access to the database. We could have a small cache and that's why it's more complicated. However it's where we are going.
David Hervieux
sounds really good! thank you!
Possibility for offline mode is to create an SQLCE DB and replicate across the DS to that local CE DB. When the user has a live connection back to SQL DB RDM will look for changes in CE DB and replicate back :)
-Brendan