Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 18 of 18 total |
Post notification to DataAware Controls |
Tue, Mar 23 2010 11:38 AM | Permanent Link |
John Hay | Rober
> I was about to print it out and noted it needs full text search on the memo fields. Perhaps this takes the time? You know how to find out <bg> > The query opened on the remote server could be a table component if I deleted some redundant fields in the server table. Perhaps that would >be quicker as I now suspect the indexes are being re-built on the client machine which could be taking up the time. Or perhaps it makes no >difference. So you are effectively streaming ther whole table? What size at the .dat, ..idx and .blb files added together? John |
Tue, Mar 23 2010 12:35 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robert,
<< I was about to print it out and noted it needs full text search on the memo fields. Perhaps this takes the time? >> Yes, that's most likely it. << The query opened on the remote server could be a table component if I deleted some redundant fields in the server table. Perhaps that would be quicker as I now suspect the indexes are being re-built on the client machine which could be taking up the time. >> Yes, the indexes have to be rebuilt on the client side. The stream format is index-agnostic and only contains the column data. This allows you to stream query result sets into tables, and vice-versa. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Mar 23 2010 2:38 PM | Permanent Link |
Robert Rowlands | Thanks for all the support.
If I remove the full text stuff the load time drops to 37 secs. If I remove 4 (out of 9) of the other indexes the load time drops to 15 secs. I'm wondering if I can do without indexes altogether being as the DevEx grids have their own DataControllers and perhaps that can replace them. Tim. Did you have any thoughts on the OnCalcFields event not firing? Thanks. Rob. |
Thu, Mar 25 2010 2:37 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robert,
<< If I remove the full text stuff the load time drops to 37 secs. If I remove 4 (out of 9) of the other indexes the load time drops to 15 secs. >> That still seems very excessive. We're talking about 3000 records, correct ? << Tim. Did you have any thoughts on the OnCalcFields event not firing? >> Sorry, I missed that at the end. Are you thinking it will run during the loading of the stream ? If so, then no, it won't fire until after the stream is loaded, and then only once. Also: << Please let me know if I should be paying for a Support Plan. >> We encourage all customers to renew their support plans. The help on the newsgroups is supposed to be peer-only, but I monitor them anyways. However, we expect everyone to be honest about renewals. It starts to become an issue, then I'll have to stop monitoring the newsgroups or change things to a "must be a customer to get an official response" policy. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Mar 25 2010 3:19 PM | Permanent Link |
Robert Rowlands | Tim
<<We encourage all customers to renew their support plans. The help on the newsgroups is supposed to be peer-only, but I monitor them anyways. However, we expect everyone to be honest about renewals. It starts to become an issue, then I'll have to stop monitoring the newsgroups or change things to a "must be a customer to get an official response" policy.>> I'll check where I am up to with the support plan. I think I may be up to date as for some reason I'd thought the support plan was 'extra' to paying for updates. Also, for the record, it transpires that the DevEx DataController creates it's own indexes so that should help speed up the remote streaming. Rob. |
Thu, Mar 25 2010 4:05 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robert,
<< I'll check where I am up to with the support plan. I think I may be up to date as for some reason I'd thought the support plan was 'extra' to paying for updates. >> No, they're one and the same - support includes access to all minor releases within the support period. << Also, for the record, it transpires that the DevEx DataController creates it's own indexes so that should help speed up the remote streaming. >> Yes, but it still is a little odd that you're seeing such large times. Did you try opening the local in-memory table exclusively ? That should speed things up tremendously. -- Tim Young Elevate Software www.elevatesoft.com |
Sun, Mar 28 2010 9:02 AM | Permanent Link |
Robert Rowlands | Tim.
The table is not being opened exclusively. I have now removed all indexes (I think the default one has to remain?) and the streaming and opening the resulting table is down to 8 seconds. That is bearable. Rob. |
Mon, Mar 29 2010 4:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robert,
<< The table is not being opened exclusively. I have now removed all indexes (I think the default one has to remain?) and the streaming and opening the resulting table is down to 8 seconds. >> Is that with Exclusive=True, or Exclusive=False ? If the latter, did you try setting Exclusive=True ? It's an in-memory table, so it shouldn't matter in terms of the client application. -- Tim Young Elevate Software www.elevatesoft.com |
« Previous Page | Page 2 of 2 | |
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 |