optimize php VS optimize the database

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

fastfingertips
Forum Contributor
Posts: 242
Joined: Sun Dec 28, 2003 1:40 am
Contact:

Post by fastfingertips »

You may boost all of this using:
1) MySQL cache memory: if you will use only one field, or a datetime field (with timestamp) you will have a static table, this means that you are able to load the table in your database server, in this way you will have the fastest access.

2) My recommendation is to use the datetime field for a simple reason: if you will process the information from that table, believe me the fastest way is to use MySQL functions to get what you need.

3) For a extreme boost you may use also a PHP caching tool, like phpa but i'm afraid that we are going to far :).
Post Reply