Speed up MySQL query - Domain Name Forum

11-20-2009, 06:52 PM

webdev

Senior Member

Join Date: Jun 2009

Posts: 7,868

Speed up MySQL query

Hey all, I have a database of around 400,000 business listings, with 30 or so fields. When a user searches by zipcode and category, the search sometimes takes a minute or two based on the amount of data in that area. Are there any corners I could cut, or simple queries I could run to speed...

__________________
Website Development
Domain Name Forum

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT -4. The time now is 12:36 AM.

| Webmaster Forum | | Domain Name Forum |