As described before, there are three components that can work with the database: DBTable, DBQuery en DBSimpleQuery. In all cases you can use the SQL builder to create your (complex) queries. There is a major thing though to take into consideration. 


  • Select the fields you really need. This will prevent loading unnecessary data, which will improve loading time and save memory.


  • Do NOT select all the joined fields. If you have created a join with tables and have all fields selected then the key values of the join of both tables will be in the select. Those have identical values, and although it might not be an issue for the sql parser, it is for PHsPeed. If you use a join, then remove one of the two fields for your select.