When you say you are showing all, does that mean that you are showing 1000 records on one page - or still just the regular 30 records per page.
Showing that many records (1000) is quite hard on PHP because it is rendering each cell, checking permissions, etc...
If you are running into performance walls, dataface has optional output caching that will improve performance some.Ê Just add the following to your conf.ini file:
[_output_cache]
enabled=1
This will create a table in your database that stores cached versions of the pages that you request. The cache will be refreshed whenever the database is changed.Ê You can also delete/empty this table to clear the cache manually.
Best regards
Steve