Need help / suggestion

[applicationsolutions]

OK, the theme is awesome first of all. I have done a bunch of modifications to it but am not done yet. My problem is this.

I am creating a post for each MLS listing for the North Texas region MLS (NTREIS). That is not the problem. The problem is, the listing details are being entered into the wp_postmeta table and there are currently 61 fields that are possibly being used per listing. There are currently approx 43,000 listings for the area. I created all 43,000 posts and it made the wp_postmeta table have well over 3 million records. I am using the plug-in WP Custom Fields Search to search the wp_postmeta table for the 3 search areas that are currently in the sidebar (MLS #, City, Zipcode). I have 7,694 listings on the website right now. If you go to the site and search by a city (pick one of the cities, it doesn't matter) it takes about 10-12 seconds to find the results. Not horrible but there are currently 373,750 records in the wp_postmeta table and when I had all 3 million records in the meta table with all 43,000 listings, it took close to a minute to find the search results. I am kind of a newbie with Wordpress but I know that there must be a better way.

What I would like to do is use another table within the wp installation (wp_mls_listings) which has all 61 fields within it. I would like to be able to perform a "join" function of some kind to search a specific column in the wp_mls_listings table with only 43,000 records vs having to have it search through a non-indexed column in the post_meta table.

Am I going about this wrong? Is Wordpress cut out to do this?

Here's the site: http://www.mouladgroup.com

I appreciate any help or direction anyone can give me.

Thanks in advance,

Adam