I have found some situations... don't knwo why... where the BeginUpdate,
EndUpdate doesn't help... and I have removed the dataset, done the query and
reattached the dataset... and it is fast.

Walter


"Tom" <tomazaz@gmail.com> wrote in message
news:D491BBBE-7AAC-4460-9B9D-004AC83E9729@news.elevatesoft.com...
> Yes, I use BeginUpdate/EndUpdate.
>
>> In my app I use QG with DBISAM and I noticed the strange thing, if I
>> set RequestLive to FALSE(return canned query)  in DBISAM 4.x - QG
>> loads records immediately. If I set to True to get live query - QG
>> start loading records extremely slow.
>
> did you use the BeginUpdate/EndUpdate for the Tableview?
>
> myTableView.BeginUpdate;
> mySQLQuery.Open;
> myTableView.EndUpdate;
>
>

Any other visual controls attached to the datasource or datasource
events used? Did you try DisableControls/EnableControls?

Sean

Walter Matte wrote:
> I have found some situations... don't knwo why... where the BeginUpdate,
> EndUpdate doesn't help... and I have removed the dataset, done the query and
> reattached the dataset... and it is fast.
>
> Walter
>
>
> "Tom" <tomazaz@gmail.com> wrote in message
> news:D491BBBE-7AAC-4460-9B9D-004AC83E9729@news.elevatesoft.com...
>> Yes, I use BeginUpdate/EndUpdate.
>>
>>> In my app I use QG with DBISAM and I noticed the strange thing, if I
>>> set RequestLive to FALSE(return canned query)  in DBISAM 4.x - QG
>>> loads records immediately. If I set to True to get live query - QG
>>> start loading records extremely slow.
>> did you use the BeginUpdate/EndUpdate for the Tableview?
>>
>> myTableView.BeginUpdate;
>> mySQLQuery.Open;
>> myTableView.EndUpdate;
>>
>>
>
>

I have posted demo in binary newsgroup with subject "QuantumGrid and DBISAM - slow performance"

Tom,

<< I have posted demo in binary newsgroup with subject "QuantumGrid and
DBISAM - slow performance" >>

It's the same problem as this thread illustrates:

http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=6&msg=9795&page=1

Frankly, I would suggest just using a LIKE comparison if you only want to
parse out text from a single column.  The way that you're executing the
query with the many, many TEXTSEARCH() calls, DBISAM is being forced to
re-parse the same text at least several hundred times per row.

--
Tim Young
Elevate Software
www.elevatesoft.com

<< I have posted demo in binary newsgroup with subject "QuantumGrid and
DBISAM - slow performance"

It's the same problem as this thread illustrates:

http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=6&msg=9795&page=1
>>

Ok, I will set LiveResult to false and use SQL in AfterPost to update REAL tables.


<<
Frankly, I would suggest just using a LIKE comparison if you only want to
parse out text from a single column.  The way that you're executing the
query with the many, many TEXTSEARCH() calls, DBISAM is being forced to
re-parse the same text at least several hundred times per row.
>>

I have tried to replace TEXTSEARCH() with LIKE but it takes even longer than with
TEXTSEARCH(). Any suggestion? How you would solve this problem?

Tom,

<< I have tried to replace TEXTSEARCH() with LIKE but it takes even longer
than with TEXTSEARCH(). Any suggestion? How you would solve this problem? >>

You are correct.  I forgot that the LIKE is going to need to be refreshed
with a live query result, meaning that the brute-force table search is going
to be re-executed many times.

--
Tim Young
Elevate Software
www.elevatesoft.com