MYSQL Query optimize and load faster

Can any one help me to make my query code optimize and load faster.
Please help me or any example what steps should we use to optimize.
Thank You

Oct 16 '08 #1

Follow Post Reply

2316

mwasif

802

Expert 512MB

Properly index your tables. Use EXPLAIN to the execution plan of your query. Also look at this.

Oct 16 '08 #2

zabsmarty

Thanks for replying me.

Oct 18 '08 #3

mwasif

802

Expert 512MB

You are welcome!

Oct 19 '08 #4

Similar topics

PHP

Import Access into MySQL

11 posts views Thread by Bruce A. Julseth | last post: by

PHP

Local Access database to shared PHP/MySql hosting export

11 posts views Thread by Mike MacSween | last post: by

MySQL Database

Strange results when optimizing LEFT JOIN in MySQL

reply views Thread by Soefara | last post: by

MySQL Database

MySQL ODBC 3.51 driver Very Slow!

11 posts views Thread by DJJ | last post: by

DB2 Database

DB2 v MySql

39 posts views Thread by Mairhtin O'Feannag | last post: by

ASP / Active Server Pages

SQL Server ou Mysql with ASP ?

8 posts views Thread by Fred | last post: by

MySQL Database

Filtered Import From MySQL to MySQL

7 posts views Thread by Randy | last post: by

Microsoft Access / VBA

Access XP / MySQL / MyODBC: Access' caching system?

6 posts views Thread by onnodb | last post: by

MySQL Database

MySQL Performance Statistics

reply views Thread by Bucker | last post: by

Microsoft Access / VBA

Next meeting for Access User Groups - Europe

3 posts views Thread by isladogs | last post: by

Software Development

What Makes Product Development Lean?

1 post views Thread by beacampos | last post: by

PHP

How do we call a function with parameters and use output returning true/false in php?

reply views Thread by bakertaylor28 | last post: by

General

openGauss security policy

reply views Thread by leo001 | last post: by

General

Forrester: Four Digital Intelligence Products of AsiaInfo Included in China Data Governance Ecology Report

reply views Thread by antdb | last post: by

General

Top Notch! AntDB database of AsiaInfo passed authoritative test of MIIT

reply views Thread by antdb | last post: by

Microsoft Access / VBA

Automatically Relink Frontend to 2 Backends via form

3 posts views Thread by bobbyer | last post: by

Microsoft Access / VBA

Group serial number

3 posts views Thread by Bright1Light | last post: by

Microsoft Access / VBA

Button hover shadow

5 posts views Thread by Bright1Light | last post: by

MYSQL Query optimize and load faster

Post your reply

Similar topics