Icon View Thread

The following is the text of the current message along with any replies.
Messages 11 to 18 of 18 total
Thread Post notification to DataAware Controls
Tue, Mar 23 2010 11:38 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PagePage 2 of 2
Jump to Page:  1 2
Image