Good morning,
In trying to optimize my app I was wondering if using server side cursors would be a good option. That idea came because of the time needed to transfert 60000 rows from my database on a 100Mb lan network to my client app. I googled and I found only one post (http://lists.mysql.com/maxdb/13354) about maxdb and those kind of cursors. The MaxDB doc only shows the "cursor functions" so I tried to create a sample app to test the efficiency of working that way. Nothing went the way I would. Here is what my sample project does :
- it creates an adodaset, connected to a classical datasource itself connected to maxdb through ODBC
- this adodataset is set to use server side cursors
- when clicking on a button the adodataset queries a big table and loops on the fifth first records and concatenate one field value of the current row into a string.
When doing this my string is still empty.
Is there something I MUST know about server side cursors ? Is there something else about server side cursor use with MaxDB ? Am I wrong in the way I expect using server side cursors ?
Thanks in advance. Xavier.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
