Mysql on windows performing very slow

Hi, If I look under task manager-> Processes, mysqld-max-nt.e uses up 99%. For simple queries, it seems to be fast, but for long and complex query, it just hangs. An example of aa query we're trying to run: SELECT ADV.AMB_No AS ColCode, CD.Company_Name AS ColDesc, ADV.Account_Item_ID AS RowCod

Re: Mysql very slow --why???

Do I need to have a clean install on my machine. Right now, I've installed the mysql server on one machine(Windows 2000) and the developer is trying to access it using the VB application from his machine(client)which is a windows 98 pc using the mysql driver. Thanks alot ---

Mysql very slow --why???

Hi, I've installed Mysql on my machine, two of my machines, one on win98 and other on windows 2000. But for some reason when the developer is trying to run any query from a VB applications, it tends to slow and hang both the machines. I 'm trying to use mysql as its supposed to be faster and bett

Re: Hoe to create indexes on existing tables

Hi ! I did try using the mysql client gui but you cant create indexes thru that. Also, since I've exported from access, the datatype all seem to be MEDIUMTEXT. So, when I try the create index syntax, ie, CREATE UNIQUE INDEX pk_code on company( ?) I am not sure what to put it the brackets

Hoe to create indexes on existing tables

Hi, I'm a bit to Mysql. We are trying to use mysql as a backend for our Visual Basic application. I had a set of tables which I exported from Access database. But now, I want to index these tables. How do I go about that? Also, any suggestions of how cursors work with mysql would be of great he