PHPCamp is place to share news, views and articles that are useful to PHP community.

Views : 352 Clicks : 48

MySQL index optimization

By nisha_singh via pixelstech.net
Submitted On December 27, 2012

We need to access a very big table which has 40 million records. In the table, id is the primary key and program_id is indexed.

1
I Like It 0
Not My Type

This is what others think

Be first to show your opinion !!!

What do you think?

Want to have your say? just login

An Experiment By AmiWorks

Join Camp Login Home Tools \| About us \| Blog \| Contact Us \| Advertising
Advertise with us Tags Frameworks Tutorials PHP Applications Methodologies Architecture Testing Tools Usablitiy Web Services SEO AJAX Javascript HTML & CSS XML Database Webservers Scaling Security Announcements Others Top Campers nisha_singh htmlcut how it works?More...	PHPCamp is place to share news, views and articles that are useful to PHP community. Boiling Getting Hotter Freshly Arrived Companies Jobs Add Your Link Login To Get Voting Rights Views : 352 Clicks : 48 MySQL index optimization By nisha_singh via pixelstech.net Submitted On December 27, 2012 We need to access a very big table which has 40 million records. In the table, id is the primary key and program_id is indexed. 1 I Like It 0 Not My Type 0 Comments Tags: Tutorials, Database Freshly Arrived Know The Dutch PHP Conference (DPC) Replace last occurance of a String jQuery Migrate 1.2.1 Released Efficiently Replicating RETS data to MySQL Creating A Multi Column Layout With CSS3 Getting Hotter nisha_singh This is what others think Be first to show your opinion !!! What do you think? Want to have your say? just login
An Experiment By AmiWorks