I have a table editor that has multiple tables. The user can switch between a data grid view of the data and a SQL window and other things.
1) How do I tune the number of rows fetched in sequential mode. I'd like to raise the batch count to say 500 at a time so there is less small fetches on fragile networks.
2) When I open a table for edit, I return an OracleDataTable which is in Open state (live), and it is bound to the grid. Since I have connection sharing, I assume the OracleDataTable holds onto this connection as long as it is open? So my current problem is since my app has connection sharing, I get an error if another operation is attempted while a table is open.
I could simply disallow the user to leave the edit tab, or close the table when he leaves the tab, but I don't want to do that. So I assume my only option is to open a 2nd DB connection? Is there any easy way to manage that? Any way to detect "this connection is busy, don't use it, get another one" ?
Sequential fetch mode tuning and OracleDataTable editing
-
- Posts: 24
- Joined: Tue 21 Sep 2010 07:17
Please use the StartRecord and MaxRecords properties of OracleDataTable to retrive limited resultset. If MaxRecords=0 and FetchAll=false, the size of the result set is determined automatically. Refer to http://www.devart.com/dotconnect/oracle ... Table.html.mrjoltcola wrote:1) How do I tune the number of rows fetched in sequential mode. I'd like to raise the batch count to say 500 at a time so there is less small fetches on fragile networks.
Specify the exact text of the error and send us a small test project with the corresponding DDL/DML script to reproduce the issue in our environment.mrjoltcola wrote:So my current problem is since my app has connection sharing, I get an error if another operation is attempted while a table is open.
-
- Posts: 24
- Joined: Tue 21 Sep 2010 07:17
-
- Posts: 24
- Joined: Tue 21 Sep 2010 07:17
Thank you.
So can I ask, does OracleTableTable even require me to open a connection before passing to the table?
My current code does:
Do I need "connection.Open()" for correctness?
So can I ask, does OracleTableTable even require me to open a connection before passing to the table?
My current code does:
Code: Select all
connection.Open();
var dataTable = new OracleDataTable(select, connection);