Hi Guys,
I wrote a small C program, which will connect to MySQL Client and execute "select * from Emp" SQL statement infinite times(say 50,000 times). After running for n(say 1000) times, Query execution time is increased, it is running very slowly.
Structure of Emp Table is Emp(EmpId INT, EmpName Char(20))
Can anybody please suggest me some parameters(MySQ L Variables) to change so that I can get results quickly.
Any suggestions are appreciated and Thanks in advance
smiles
sarma
I wrote a small C program, which will connect to MySQL Client and execute "select * from Emp" SQL statement infinite times(say 50,000 times). After running for n(say 1000) times, Query execution time is increased, it is running very slowly.
Structure of Emp Table is Emp(EmpId INT, EmpName Char(20))
Can anybody please suggest me some parameters(MySQ L Variables) to change so that I can get results quickly.
Any suggestions are appreciated and Thanks in advance
smiles
sarma