[sqlite] ASK matchinfo performance

2016-03-17 Thread Christoforus Surjoputro
Hi Daniel, thanks for reply. So it's better to upgrade sqlite that support fts5? I've tried to find how to use latest sqlite in python but there is no help. I should build python from source that I don't want it. Btw, when I need to rank for relevancy, is I must use x parameter? Thank you.

[sqlite] ASK matchinfo performance

2016-03-17 Thread Dan Kennedy
On 03/17/2016 12:27 PM, Christoforus Surjoputro wrote: > 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

[sqlite] ASK matchinfo performance

2016-03-17 Thread Christoforus Surjoputro
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