Server side cursor
Xavier CAMIER <[email protected]>
| Newsgroups | gmane.comp.db.maxdb |
|---|---|
| Message-ID | <[email protected]> |
Win XP SP2
MaxDB Linux 7.6.00.34
Turbo Delphi 2006
ODBC 7.6.00.34
Hi list,
I need to display a grid with a large amount of datas. I know I
shouldn't but I must do it anyway :-( To prevent network overload and
large form opening times I decided to test server side cursors. The test
project is quite simple : a dbgrid with a server side cursor recordset.
Using delphi and ADO I must set the recordset as beeing a readonly
keyset. The datas are retrieved as they should and about as fast as they
should (a little bit slower than when using SQL Studio anyway. Does
anybody know why ?). My problem happens when I scroll the datas too
fast. When scroll using the DBGrid the app hangs. When I do it using
code (simple loop through the datas) the app crashes sending a "Access
violation to address... in MSDATL3.dll" error message depending on how
large the cache is set. I thought the problem came from MDAC but when
moving my test application to a PostgreSQL database it works fine. So I
think the problem comes from MaxDB's ODBC driver. Does anybody knows
about that ?
Kind Regards
Xavier
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[email protected]