Re: [PERFORM] big data - slow select (speech search)

2010-07-07 Thread Michal Fapso
u, Jul 1, 2010 at 6:34 PM, Michal Fapso wrote: >> It took about 4.5 seconds. If I rerun it, it takes >> less than 2 miliseconds, but it is because of the cache. I need to >> optimize the first-run. >> >> laptop ASUS, CPU dual core T2300 1.66GHz, 1.5G RAM >> >

Re: [PERFORM] big data - slow select (speech search)

2010-07-01 Thread Michal Fapso
x27;/the/full/path/synthetic_data.sqlcopy'; Best regards, Miso Fapso On 2 July 2010 00:34, Michal Fapso wrote: > Hi, > > I have quite a simple query but a lot of data and the SELECT query is > too slow. I will be really grateful for any advice on this. > > --

[PERFORM] big data - slow select (speech search)

2010-07-01 Thread Michal Fapso
Hi, I have quite a simple query but a lot of data and the SELECT query is too slow. I will be really grateful for any advice on this. -- The background info: I work on a speech search engine which differs from text search in having more words (hypo