Hello, We are setting up a mysql database for working with and manipulate large amounts of data.
I'm using a visual basic script for manipulating particular rows in every record in a test-database with almost 65.000 records. This script is checking the spaces in row and put this in several variables. With these variabel we later get blocks of these data en put them in another row. Currently we are working with ms access but are testing mysql for performance. Untill now mysql is slower than msaccess. In this vb script we connect to the mysql server with odbc and adodb. server-sides query's and optimistick locking. The Redhat MySQL server ( pentium III 733mhz, 128mb memory ) is showing a 100% CPU usage when I run the visual basic code, memory is not a problem ! Does somebody have some ideas to increase the performance of MySQL ? With thanx in advance. Teus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
