Customization - DailyWP ClassifiedEngineTheme

This theme is a classified theme - Pls see demo : [login to view URL] Need you to rectify dev coding problem We have 99.9 set up the site - only upon we uploaded 28 k ad list then hostgator told us due to bad coding of the dev causing keep hitting on their server resulted memory fatal error. Pls see below Hostgator advice : “it should not take that much.. while reading data he should limit the data.. and when ever require he should read remaining data” "When running the ads page under a debugging utility, it is endlessly trying to load data until it hits our 256 MB memory limit and then dies" "For what its worth, I’m not sure who coded your ads plugin for wordpress, but the fact that its trying to load all that information at once means its not coded great. If it were coded to only load a certain bit of information at a time” "The reason that you are having the issues that you are with adding these 6 new Ads is for the following reason: The following Database query is attempting to run and is running out of memory: "SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN ( {This is scanning ALL of your posts}46038,46039,....,{this is only a partial printout of all the posts that this query is searching}) made by require, wp, WP->main, WP->query_posts, WP_Query->query, WP_Query->get_posts, update_post_caches, update_postmeta_cache, update_meta_cache Unfortunately what is happening here is your query is so large that your user account is running out of Memory for this process and as such you are getting the errors that you have been experiencing. There is a chance that if you limit the number of posts that this query is using from All of them to say 2000 or 3000 then you should be able to accomplish this task." We need this task to be complete soonest Pls send us your quote and completion time needed