514756 Slow PHP script optimization (CodeIgniter)

Please visit [url removed, login to view] for the script. You will notice that it takes very long to load the main page and some category pages.

It's fully functioning, however recently I've had 2 new modifications added to the php codeigniter content management script:

- Add star rating on the category pages and main page

- Add sorting on main page

After these modifications were implemented the script now works VERY slow. I found out what the problem is, the queries that were used for the star rating on the category/main page and to sort just take too long to complete.

Here is an example of a query:

SELECT `g_added` AS dat, `g_id` AS id, `g_section` AS scn, `p_filename_thumb` AS img, `total_value`, `total_votes` FROM (`galleries`) JOIN `pictures` ON `pictures`.`p_g_id` = `galleries`.`g_id` LEFT JOIN `ratings` ON `ratings`.`id` = CONCAT('P', galleries.g_id) WHERE `g_enabled` = 1 GROUP BY `g_id` ORDER BY `g_added` DESC LIMIT 12;

This query takes over 30 seconds to complete.

I am looking for a programmer who can fix the slowdown on the script and make it work normal again.

I have attached two main script functions that is causing the problem for the main page ([url removed, login to view]). I still dont know what is causing the slowdown on the category pages.

Looking forward to any bids.

Thank you.


Beceriler: Her şey Kabul, Codeigniter, PHP, Kabuk Betiği, Web Sitesi Yönetimi

Daha fazlasını gör: codeigniter slow, codeigniter load page slow, codeigniter optimization, the p.i.c. group, php main functions, p&a group, order programmer php, codeigniter 2, category php id, index php id, the php group, Query optimization, php codeigniter, gs-1, fix slow, codeigniter script, join codeigniter, codeigniter join left, select join codeigniter, left join codeigniter, codeigniter join, slow queries, codeigniter left join, codeigniter sort, work management script

İşveren Hakkında:
( 32 değerlendirme ) Marmaris, Turkey

Proje NO: #2260688



let me help you fix that. Thanks

%selectedBids___i_period_sub_7% gün içinde 75%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(958 Değerlendirme)