tags:

views:

128

answers:

2

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
+1  A: 

Maybe you should try out MySQL's query profiler or you can simply measure it with PHP.

fabrik