September 05, 2008, 17:03:14 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Add your links to our directory. Click here to add your links.
 
  Home   Forum   Help Search Directory Calendar Login Register    RSS 2.0 feedAtom feed


News
Add your links to our directory. Click here to add your links.
IT Resources
Pages: [1]
« previous next »
  Print  
Author Topic:

Slow queries

 (Read 886 times)
0 Members and 1 Guest are viewing this topic.
spiderx
Jr. Member
**

Points: 3
Offline Offline

Posts: 62
« on: October 14, 2006, 13:06:39 »
hi,

 I just finished a program for some clients and I noticed is working very slow. After some investigations I discovered some querys what are working very very slow. The database doesen\t have right bow mor ethan 100 000 rows but in short time will be double. How can I find the glitch ? Mysql have some tools for profiling ?

Thanks
Logged
Regards
Spider X


TheGodFather
Administrator
Hero Member
*****

Points: 202
Offline Offline

Posts: 2570



WWW
« Reply #1 on: October 14, 2006, 15:07:38 »
Just post here the querys and table structure and indexes or use explain function. With explain we ca see where are the botlenecks in your querys

Regards
Logged
█ Deleted Domains
█ Hostmaster Web Tools
█ Webmaster Web Tools
scolls
Jr. Member
**

Points: 0
Offline Offline

Posts: 19


WWW
« Reply #2 on: November 11, 2006, 00:21:17 »
Yes it does, try using "explain" before a query to see how it's performing.

eg. 'explain select * from bollocks'

If you can run explain on your problem query and post the results here it would be much easier to find the problem at a glance.
Logged
WebWobot Search Engine | Search Engine Forums | le-Magasin.ch ~ Annuaire d'e-Commerce
Pages: [1]
  Print  
« previous next »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.4 | SMF © 2006, Simple Machines LLC
Seo4Smf v0.2 © Webmaster's Talks
TinyPortal v0.9.7 © Bloc 		Valid XHTML 1.0! Valid CSS!