Navigation

If you feel that one of your pages takes more time than it should to be
generated, chances are that you’re making too many RQL queries. Obviously,
there are other reasons but experience tends to show this is the first thing to
track down. Luckily, CubicWeb provides a configuration option to log RQL
queries. In your all-in-one.conf file, set the query-log-file option:

You should also know about the profile option in the all-in-on.conf. If
set, this option will make your application run in an hotshot session and
store the results in the specified file.

Last but no least, if you’re using the PostgreSQL database backend, VACUUMing
your database can significantly improve the performance of the queries (by
updating the statistics used by the query optimizer). Nowadays, this is done
automatically from time to time, but if you’ve just imported a large amount of
data in your db, you will want to vacuum it (with the analyse option on). Read
the documentation of your database for more information.