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.