MYSQL speed Issue
-
Dear All, I have been developing databases with mysql as a backend from past a year. presently i have got a problem with speed in mysql. this is really unbeliveable for me. I have tables which has 15000 records, if i am joining two table and i want to retreive data, it takes more than 20 second to execute the query and return the result. any idea what can be done to increase the speed. in bellow i have both MySql version and my computer specifications. MySql version 5.1 My Computer Specification HP DV5 4GB RAM/2GHz core DUO 2 any solutions really appreciated.
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
-
Dear All, I have been developing databases with mysql as a backend from past a year. presently i have got a problem with speed in mysql. this is really unbeliveable for me. I have tables which has 15000 records, if i am joining two table and i want to retreive data, it takes more than 20 second to execute the query and return the result. any idea what can be done to increase the speed. in bellow i have both MySql version and my computer specifications. MySql version 5.1 My Computer Specification HP DV5 4GB RAM/2GHz core DUO 2 any solutions really appreciated.
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan
-
Dear All, I have been developing databases with mysql as a backend from past a year. presently i have got a problem with speed in mysql. this is really unbeliveable for me. I have tables which has 15000 records, if i am joining two table and i want to retreive data, it takes more than 20 second to execute the query and return the result. any idea what can be done to increase the speed. in bellow i have both MySql version and my computer specifications. MySql version 5.1 My Computer Specification HP DV5 4GB RAM/2GHz core DUO 2 any solutions really appreciated.
Abdul Rahaman Hamidy Database Developer Kabul, Afghanistan