Hi Rajish, > -----Original Message----- > From: rajish nair [mailto:[EMAIL PROTECTED] > Sent: Sonntag, 8. Februar 2004 10:18 > To: [EMAIL PROTECTED] > Subject: performance query with visual basic 6 > > > Hi All, > we are using a machine with 128MB RAM and 1.6 GH > pentium 4.We conducted a performance test for sql > server and maxdb on windows . sql server took 43 > seconds for insertion of 15000 records while maxdb was > able to complete the task in 61 sec.Our client program > was written vb 6.0 and used odbc driver 7.5 for > maxdb.Any suggestion regarding improving performance > of maxdb with visual basic 6.0.
Mass inserts are a somewhat weaker point in the current version of the ODBC driver. This will change with the new ODBC driver based on SQLDBC (a C++ state-of-the-art interfaces for MaxDB) that will be available during this year. Selects should be much faster and are usually the more often used kind of data transfer of client software. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP DB, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
