get result of search in database postgresql and work with it every time

Posted on

Question :

I have a query who spend alot of time because there is thousand of ligne in the database, so I need if it’s exist a method to put the result of the query some where and work with them the time i want. thanks

Answer :

From PostgreSQL’s point of view you can use Materialized Views or Unlogged Tables

For other solutions you can check different caching mechanisms

Leave a Reply

Your email address will not be published. Required fields are marked *