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
>>
>
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.
>
> --
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