Info Window run Query twice

Description

we made some testing - with product info. search %textstring% tooks 13 sec.
After analyse dabase with pgbadger, explain me the most slower normalised query tooks 7,5 second.

and investigate to code and looks info window query data twice

chat with hieplq
....one time for get number of record with current query parameter to know how many page
one time for request data for current page

I understand this BUT i suggest to improve it "somehow" with really new concept, doesnt require run query 2x.

This is not problem with small datasets,. But with Select with 4-5 joins really waste cpu time.

, im interested well, what is yours opinion here.

n

Environment

None

Assignee

Hiep Lq

Reporter

Norbert Bede

Labels

Tested By

Carlos Ruiz

Components

Affects versions

Priority

Major
Configure