some more info.... */proc/cpuinfo* processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Celeron(R) CPU 2.66GHz stepping : 1 cpu MHz : 2667.031 cache size : 256 KB fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc up pni monitor ds_cpl tm2 cid cx16 xtpr bogomips : 5340.26
Is there any specifications, a table should not contain more than N number of records...... This count(id) am doing for experimentations, not only this query all the queries are taking much time... Any idea on this ??? how to make queries to execute faster when the number of rows are nearly 50 lakh
