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...
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.
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-phpThis 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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.