I would bet 99.9% of the problem is you aren't using indexes. Run an explain on your queries that will show you were the problem probably is.
Donny > -----Original Message----- > From: Teus van Arkel [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 22, 2004 6:11 AM > To: [EMAIL PROTECTED] > Subject: Performance > > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
