lslackware Posted September 16, 2008 Report Share Posted September 16, 2008 (edited) Sveiciens, Dots: lapa ar PHP/MySQL. Dotajā lapā notiek divi MySQL inserti. Problēma: Lapas apstrāde ir ļoti lēna :( Jautājums: Kā varam noteikt uz kuru tieši no dotajiem insertiem, ir patērēts visvairāk laika? Vai ir iespējams redzēt precīzi ko tieši tagad dara MySQL? Paldies! Edited September 16, 2008 by lslackware Link to comment Share on other sites More sharing options...
codez Posted September 16, 2008 Report Share Posted September 16, 2008 (edited) http://dev.mysql.com/doc/refman/5.1/en/using-explain.html Pašam insertam nevajadzētu aiņemt laiku, jāskatās vai kāds select nav nefektīvi izveidots vai noindeksēts. Edited September 16, 2008 by codez Link to comment Share on other sites More sharing options...
Pentiums Posted September 16, 2008 Report Share Posted September 16, 2008 izmanto šo microtime Link to comment Share on other sites More sharing options...
lslackware Posted September 16, 2008 Author Report Share Posted September 16, 2008 Paldies! Link to comment Share on other sites More sharing options...
Recommended Posts