Everything posted by duframe
Thanks for the reply. I will have 25 results per page to break it up. I really want to try and return the results using less resources. I figured that so many queries running at the same time with so many records in so many tables would really slow it down. My goal is to gauge for large amounts of traffic and have efficient code and queries to handle it fast. Do you think I am over thinking it? Perhaps my query could be optimized. SELECT table1.p_id, table1.r_name, table1.account_activated, table1.r_phone, table1.r_fax, table1.r_address_1, table1.r_address_2, table1.r_city, table1.r_postal, table1.r_state, table1.r_description, table1.r_genre_1, table1.r_genre_2, table1.r_genre_3, table1.r_genre_4, table1.r_genre_5, table1.r_date_added, table1.r_rate_store, table1.r_rate_store_total, table1.order_online, table1.online_delivery, table1.online_delivery_start, table1.online_delivery_end, table1.gift_certs, table1.RSS, table1.rewards_programs, table1.url, p_details.delivery, table1.r_lattitude, table1.r_longitude, ( 3959 * acos( cos( radians(40.745564) ) * cos( radians( r_lattitude ) ) * cos( radians( r_longitude ) - radians(-73.977736) ) + sin( radians(40.745564) ) * sin( radians( r_lattitude ) ) ) ) AS howfar FROM table1, p_details WHERE p_details.size = 1 and p_details.external = 1 and p_details.usb = 1 HAVING howfar <= 3 ORDER BY howfar would a join make this run faster?