I have a table (mysql) with 66,00,000 records.
now does anyone help me how to handle this table in php/mysql.
my requirement is to search a record based on certain criteria.
handling heavy tables in mysql/php
Moderator: General Moderators
-
ashok.pintu
- Forum Newbie
- Posts: 1
- Joined: Fri Aug 01, 2008 4:13 am
- jaoudestudios
- DevNet Resident
- Posts: 1483
- Joined: Wed Jun 18, 2008 8:32 am
- Location: Surrey
Re: handling heavy tables in mysql/php
I would index your searchable columns to improve search performance
Re: handling heavy tables in mysql/php
You're going to need table partitioning, you can set up table partitioning in mysql so mysql can divide the data into more discrete groups, for instance records 1-10M are in partionA on the disk, records 10-20M in partionB, etc...
You can set up partitioning in different ways based on the data you are trying to display. With a table of that size you may need some logic on your application based on what you are trying to do, such as caching or job queues. Can you give us more info on what kind of data youre working with and how youre using / manipulating it?
http://dev.mysql.com/doc/refman/5.1/en/ ... types.html
You can set up partitioning in different ways based on the data you are trying to display. With a table of that size you may need some logic on your application based on what you are trying to do, such as caching or job queues. Can you give us more info on what kind of data youre working with and how youre using / manipulating it?
http://dev.mysql.com/doc/refman/5.1/en/ ... types.html