0

Hi Friends,

In the website in which i am developing for every searches made an entry would be made in a table. As a result of this the size of the table grows to great extend. Now i am planning to take the backup of that table periodically and to clean it. this helps to reduce the loading time of sections related to this table,

Now can u give me some valuable solution for this problem...Can i do this ....any idea to implement this from ur side...

Looking for your valuable replies...

2
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by tnchitra
0

Thanks for your suggestion. I will check this with our Client and do this..

Thank you once again..

If I were you, I would run a cron job, once a week perhaps.

An example function using PHP for backing up your DB can be found here:
http://davidwalsh.name/backup-mysql-database-php

This could be easily modified to remove backed up records.

Furthermore, ensure you have indexes on your tables to help make them faster when searching.

R.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.