query optimization

Expand Post »

Hai friends
previously I have optimized the query using index that time in my database only 65000 record ,right now in my database 1,50000 recoreds so i need again optimize the query .Now my site loaded very slow . Please give me any suggestion how to optiminze the query agian .
Thanks
vssp

Similar Threads

Query on a large table too slow in MySQL
Opinion on Software Project (Sharing Ideas) in Computer Science
All you need for Search Engine Optimization (SEO) in Search Engine Optimization
All You Need for SEO (Search Engine Optimization) - Resources List in Search Engine Optimization
Query optimization in PHP

vssp

Reputation Points: 5

Solved Threads: 5

Junior Poster

Offline

197 posts
since Jul 2006

Permalink

Jul 13th, 2006

Re: query optimization

Try defragment it to cure slowness.

zippee

Reputation Points: 10

Solved Threads: 7

Posting Whiz in Training

Offline

294 posts
since Jan 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: session_start(): Cannot send session cache limiter -

Next Thread in PHP Forum Timeline: PHP menu link causes error

DaniWeb Message

Cancel Changes

User Name
Password