Marcin: This heppens everytime when i try to query different keyword in FTS for example:
firsttime: query: "Hello & World" 15sec~ secondtime: query: "Hello & World" 2-3sec then new query firsttime: query: "We & are & good" 10sec~ secondtime: query: "We & are & good" 2-3sec even if i'm going from CMD queries are faster but on first time always it's slower then rest of the times. On Sun, Jun 23, 2013 at 9:57 PM, Marcin Mańk <marcin.m...@gmail.com> wrote: > On Wed, Jun 5, 2013 at 1:15 PM, Emrah Mehmedov > <emrah.mehme...@x3mlabs.com> wrote: > > [ull text search] > > I notice something in CMD, first time query is executing same time like > from > > php all the time, but on the rest of the time that i will execute the > query > > is faster from cmd, php is keeping the same execution time. > > i also change the connection string (i remove host and port) and nothing > > changed. > > The first query using a text search config loads the dictionaries, so > it is slower, and that's why the following queries are faster. I think > your PHP persistent connections don't work too well. > > Regards > Marcin Mańk > -- Best regards, Emrah Mehmedov Software Developer @ X3M Labs http://www.extreme-labs.com
