Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 16 total |
QuantumGrid and DBISAM - slow performance |
Thu, Nov 30 2006 3:34 AM | Permanent Link |
Tom | 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 |
Thu, Nov 30 2006 12:02 PM | Permanent Link |
"Enrico Ghezzi" | > 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. |
Thu, Nov 30 2006 2:24 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Nov 30 2006 2:26 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Nov 30 2006 2:42 PM | Permanent Link |
Tom | No, there is no Order By.
I use such query SELECT * FROM Topic Where TEXTSEARCH('17977' IN CategoriesID) |
Fri, Dec 1 2006 1:49 AM | Permanent Link |
Tom | 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. |
Fri, Dec 1 2006 5:13 AM | Permanent Link |
"Ralf Bertoldi" | 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 |
Fri, Dec 1 2006 1:58 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Dec 1 2006 2:51 PM | Permanent Link |
Tom | 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; |
Fri, Dec 1 2006 2:51 PM | Permanent Link |
Tom | 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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |