Im using Mysql server version 5.1 and we have nearly 2 lakh records I need to know how much time will the mysql query takes to complete for Insertion, deletion, updation and for selection. Can anybody help me?
+1
A:
Record the time before the operation, perform the operation, and record the time after the operation.
JoshJordan
2009-08-11 13:41:05
+1
A:
Maybe you should try out MySQL's query profiler or you can simply measure it with PHP.
fabrik
2009-08-11 13:43:35