Database maintenance
In the root directory of jobberBase, there’s a cron_maintenance.php script that you should run with cron (or Task Scheduler, on Windows). On jobber.ro, I have that script running every night.
Default maintenance
For now, what the maintenance script does is delete temporary and inactive job ads.
What else can you do
The standard job-board behavior is to allow an ad to be active for a number of days (30, for most of them). If you wish to implement this in your jobberBase-based site, you could use the cron_maintenance.php to deactivate older ads and/or notify publishers with 2-3 days before this deactivation…
I’m guessing that an OPTIMIZE TABLE jobs; would also be useful, from time to time :).
comments
One Response to “Database maintenance”
Leave a Reply
-
Subscribe to RSS
-
Recently Written
- Version 1.4 final…ly here!
- John Resig (creator of jQuery) on jobberBase
- jobberBase on Rails
- Thank you! :)
- 5k downloads of jobberBase
- 1.4, the most impressive update yet!
- Need someone to further develop jobberBase?
- Multi-language, soon!
- Consider the SVN repository
- 1.3 is out with goodies: admin panel
-
Categories
-
Archives
-
Links
sal. sper ca e ok sa vb in romana.
eu nu am background de programator, dar incerc sa implementez jobberbase.
crezi ca poti sa imi spui ce comanda sa pun la cron in cpanel pt a rula scriptul?
merci.