Jump to content
RockWare Support Forum
d.campbell13

RW17 SQL database limitations

Recommended Posts

With the change from Access (MDB) database structure in RW16 to SQL in RW17, are there any suggested size limits for an efficient RW17 project in terms of the number of wells or amount of data? Having used Access databases in a number of similar type programs, there seemed to be a limit of +/- 300 wells at which point database queries became very slow. Something similar occurs in RW16 when you have a lot of P-data (> 500k data points per well including nulls).

​Regards,

David Campbell

Share this post


Link to post
Share on other sites

The size limitation goes away with SQLite and its faster than Access. However very large amounts of P-Data will still slow you down, just not as much. On the processing side multi-core processing for many algorithms, 64bit memory space and improved design help speed things up. Of course if you use the larger memory space to make larger models there will be a performance penalty.

I'll let our Database guru Jim Jackson chime in with more specific details.

Share this post


Link to post
Share on other sites

The limitations of an SQLite database can been seen at www.sqlite.org/limits.html. You should see a performance improvement over using MS Access (mdb) as the SQLite engine is embedded in RockWorks where using MS Access the data had to move (be marshaled) from Access to RockWorks across the COM interface. If you mean MS SQL Server, the limits can been seen at msdn.microsoft.com/en-us/library/ms143432.aspx. With MS SQLServer some of the processing is done on the server but the network latency comes into play. We try to have the server only send back the data for the process at hand, but again large P-Data model will be slow.

So I do not have any hard and fast suggestions for limiting the number of boreholes or the amount of data for a borehole, it depends on what you are doing with the data in RockWorks. Once the data is in, you can disable some boreholes.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×