Đang Thực Hiện

139657 Database optimization/indexing

I have a business directory script called phpmydirectory. I am looking for someone to optimize the database structure and code access the database. Also set up proper indexing. for example LEFT JOIN in query rather than the way it queries using PHP to correlate them. Also setting up proper indexing for the database. Or providing a different more efficient business directory script with the same or better features that is set up to handle up to 14 million listings.

At this time I have removed all but a a few thousand listings because of the slowness. Once I get up around a few hundred thousand it slows way down. I have checked with the host company. It is not the server rather the items described above.

Here is a link to the current directory.

[url removed, login to view]

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: www phpmydirectory com, link optimization, Query optimization, database queries, database optimization, described structure, queries database, code database access, optimization database, phpmydirectory database, php server optimization, link access database, query optimize, mysql join, optimize php mysql, mysql query optimization, access code database, business directory php mysql, using access database, query optimize mysql, php script database query, mysql queries using, mysql query example, php script access mysql database, business optimization

Về Bên Thuê:
( 3 nhận xét )

ID dự án: #1885832