Using data caching in general makes design of the application more easy and straight forward, as long as you keep the following in mind:


  • Caching set to true:

If you have a basic query, for instance all the employees of an department, then accessing the table will not refresh the data while remaining in the same application. If you need to change the search to another department then you must set a new filter and reopen the database table.

  • Caching set to false:

The result set will be refreshed after each operation. 

But either way, in both situations the cache database is used as it is required for bidirectional access. The difference is the timing when the resultset after a query is refreshed. 

It is very important that if you have a lookup field, i.e. to retrieve the description of a department based upon a key value, that you set caching of this search to false. Otherwise the lookup will not refresh. It is set by default by PHsPeed, but can be overwritten.

DBSimpleQuery is mainly used within your PHP code. If used with a query then the result is always sequential.



While caching the result is only valid within the same application. As soon as you jump into another module then the resultset is destroyed. Of course when you re-enter the module a new resultset based upon the current query will be created.