Hi,

I know that it is not directly related with DBISAM but I am sure many
programmers here use DBISAM with QG and I hope I will get suggestion to my problem.

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.

Previously I have used DBISAM 3.x version with older version of QG and everything worked fine.

Regards,
Tomas

> I know that it is not directly related with DBISAM but I am sure many
> programmers here use DBISAM with QG and I hope I will get suggestion to my
> problem.
>
> 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.

yes it's true


QGrid use LOCATE for move internal record on the table

but Dbisam don't use any Index for good result.  

Enrico,

<< QGrid use LOCATE for move internal record on the table

but Dbisam don't use any Index for good result.   >>

DBISAM 4.x uses indexes in all locates, including those on query result
sets.  3.x didn't use indexes of query result sets.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tom,

<< I know that it is not directly related with DBISAM but I am sure many
programmers here use DBISAM with QG and I hope I will get suggestion to my
problem.

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

Is there an ORDER BY in the query's SELECT statement ?

--
Tim Young
Elevate Software
www.elevatesoft.com

No, there is no Order By.
I use such query
SELECT * FROM Topic Where TEXTSEARCH('17977' IN CategoriesID)

Forgot to say, I use 4.22 version, maybe I need to download and use newest version?
But I am not sure is this help.

Tom wrote:

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

HIH
Ralf

Tom,

<< No, there is no Order By.
I use such query
SELECT * FROM Topic Where TEXTSEARCH('17977' IN CategoriesID) >>

Okay, give me a day here to set up a test with the QuantumGrid components to
see if I can replicate the situation.  I will let you know what I find out.

--
Tim Young
Elevate Software
www.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;

Tim, if you want I could send my own demo with my database.




"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Tom,

<< No, there is no Order By.
I use such query
SELECT * FROM Topic Where TEXTSEARCH('17977' IN CategoriesID) >>

Okay, give me a day here to set up a test with the QuantumGrid components to
see if I can replicate the situation.  I will let you know what I find out.

--
Tim Young
Elevate Software
www.elevatesoft.com