Hi all. I've example database that can be downloaded here http://www.megafileupload.com/rhqU/product.db or you can generate yourself by using this python script:http://pastebin.com/4djPZJ21
I try to compare performance between standard query and using matchinfo() function.Standard queryt:http://pastebin.com/RFZwx8AJ matchinfo():http://pastebin.com/BBq28HNh Script that use matchinfo() function about 20x slower than standard query. Is that normal or something wrong with my query or my database? And how to improve the matchinfo() performance?