Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread Database with lots of records
Fri, Nov 2 2012 4:58 PMPermanent Link

Carlos

Hi and thanks in advanced for the Help.

I guess that this in a malfunction in the Program.

I have this table with around 450.000 records in MSSQL Server, never had a single problem obtaining records via the below query if I get

When I create a dataset using the dataset manager, and I enter the below Query string

SELECT * FROM PSHEETS WHERE EMPL_ID = '12345'    

I then click on the preview tab to see the results, on the bottom of the form there is a label which says "Obtaining Data " it goes like that for about 30 seconds, then the label changes to Disconnected, and I see no Data results.

I should get out of that query around 300 records, instead I get 0 records

Is this a bug with large data tables?


Thanks

Regards,

Carlos
Mon, Nov 5 2012 2:42 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Carlos,

<< When I create a dataset using the dataset manager, and I enter the below
Query string

SELECT * FROM PSHEETS WHERE EMPL_ID = '12345'

I then click on the preview tab to see the results, on the bottom of the
form there is a label which says "Obtaining Data " it goes like that for
about 30 seconds, then the label changes to Disconnected, and I see no Data
results.

I should get out of that query around 300 records, instead I get 0 records

Is this a bug with large data tables? >>

EWB is simply using the ADO data access components for accessing the data,
so if there is any issue with the query/MS SQL Server/ADO components, then
you'll run into an issue with the EWB DataSet Manager.   Do you use Delphi ?
If so, then you can try the same query using Delphi and the ADO components
to emulate the same type of access and see what the issue is.

I suspect that the issue is that every row in the result set is being
fetched, and that is accounting for the slow response.

Tim Young
Elevate Software
www.elevatesoft.com
Mon, Nov 5 2012 4:54 PMPermanent Link

Carlos

Good afternoon Sir, and thanks for the response.

Yes, I use Delphi and this behavior does not happen when I use this query with an ADO component under Delphi, and the result comes instantly. As a matter of fact I have a windows application that I build using Delphi 2010 using ADO components, is been used by about 800 users in a daily basis and pounding this Table with queries and never a hiccup. I will try to create a screen-cast, send you the link, so you can see, and perhaps see what is going on.


Thanks so much

Regards,

Carlos


"Tim Young [Elevate Software]" wrote:

Carlos,

<< When I create a dataset using the dataset manager, and I enter the below
Query string

SELECT * FROM PSHEETS WHERE EMPL_ID = '12345'

I then click on the preview tab to see the results, on the bottom of the
form there is a label which says "Obtaining Data " it goes like that for
about 30 seconds, then the label changes to Disconnected, and I see no Data
results.

I should get out of that query around 300 records, instead I get 0 records

Is this a bug with large data tables? >>

EWB is simply using the ADO data access components for accessing the data,
so if there is any issue with the query/MS SQL Server/ADO components, then
you'll run into an issue with the EWB DataSet Manager.   Do you use Delphi ?
If so, then you can try the same query using Delphi and the ADO components
to emulate the same type of access and see what the issue is.

I suspect that the issue is that every row in the result set is being
fetched, and that is accounting for the slow response.

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Nov 14 2012 10:50 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Carlos,

<< Yes, I use Delphi and this behavior does not happen when I use this query
with an ADO component under Delphi, and the result comes instantly. As a
matter of fact I have a windows application that I build using Delphi 2010
using ADO components, is been used by about 800 users in a daily basis and
pounding this Table with queries and never a hiccup. I will try to create a
screen-cast, send you the link, so you can see, and perhaps see what is
going on. >>

This has now been fixed and I should have a new build available by the end
of the week.  The build timing got delayed due to some other bugs and some
other things that I wanted to work on with EWB before the release of the
build.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Sat, Dec 29 2012 3:42 PMPermanent Link

Carlos

Hi Tim and happy holidays,

I was wondering if this was already fixed and if there is an update that I can download.

Thanks

Regards

Carlos

"Tim Young [Elevate Software]" wrote:

Carlos,

<< Yes, I use Delphi and this behavior does not happen when I use this query
with an ADO component under Delphi, and the result comes instantly. As a
matter of fact I have a windows application that I build using Delphi 2010
using ADO components, is been used by about 800 users in a daily basis and
pounding this Table with queries and never a hiccup. I will try to create a
screen-cast, send you the link, so you can see, and perhaps see what is
going on. >>

This has now been fixed and I should have a new build available by the end
of the week.  The build timing got delayed due to some other bugs and some
other things that I wanted to work on with EWB before the release of the
build.

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com
Wed, Jan 2 2013 5:18 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Carlos,

<< I was wondering if this was already fixed and if there is an update that
I can download. >>

Yes, EWB 1.01 Build 3 fixes this:

http://www.elevatesoft.com/incident?action=viewrep&category=ewb&release=1.01&incident=3691

Tim Young
Elevate Software
www.elevatesoft.com
Image