TVirtualQuery

TVirtualQuery

Postby Aggie85 » Thu 18 May 2017 01:27

Howdy All!

I am trying to replace TxQuery with TVirtualQuery.

I primarily use TkbmMemTable in my application framework.

I have tried the following:

1) Added a TkbmMemTable to my form called TestDataTable.
2) Added a TVirtualQuery to my form called VQuery.
3) Added TestDataTable to VQuery's SourceDataSets collection and I called the TableName TestData.

At run-time, I populate the TestData with 10000 records with a primary integer key field.
I add the following statement to the SQL property of VQuery:

DELETE FROM TestData WHERE RecordID >= 5000;

It should delete 5000 records but it only deletes 1.

Am I using TVirtualQuery wrong or is it incompatible with TkbmMemTable (memory table)?

Thanks,

Shane
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby Aggie85 » Mon 22 May 2017 19:25

Any chance of getting this answered before I retire :D ?

All the best,

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby MaximG » Tue 23 May 2017 14:33

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.
MaximG
Devart Team
 
Posts: 740
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualQuery

Postby Aggie85 » Tue 23 May 2017 18:05

Thanks!

I really hope y'all get this working so I can replace TxQuery. Unfortunately, replacing TkbmMemTable isn't going to happen anytime soon!

All the best,

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby MaximG » Wed 24 May 2017 12:21

Thank you for the information. We have reproduced the problem and fixed the bug. The fix will be included in the next VirtualDAC build. Currently, we can send you a night build of VirtualDAC with the fix. For this, please specify your license number and the exact version of Delphi you are using. Please send this data using the e-support form ( https://www.devart.com - menu «Support»\«Request Support» )
MaximG
Devart Team
 
Posts: 740
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualQuery

Postby Aggie85 » Sat 17 Jun 2017 02:56

Howdy Max!

A follow up with TVirtualQuery and TkbmMemTable.

If I have a table with 10,000 records with a RecordID value of 0 to 9999 and I issue the following:

1) DELETE FROM TEST WHERE RecordID < 10

10 records are deleted.

2) DELETE FROM Test WHERE RecordID IN (0,1,2,3,4,5,6,7,8,9)

only deletes 1 record.

Again, this is with TkbmMemTable with I cannot stop using. A TVirtualTable it works fine.

Let me know if you need any help with this.

All the best,

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby MaximG » Mon 19 Jun 2017 10:51

Thank you for the information. We have reproduced the issue and will investigate its origin. We will inform you about the results shortly.
MaximG
Devart Team
 
Posts: 740
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualQuery

Postby Aggie85 » Mon 19 Jun 2017 19:27

Howdy Max!

Thanks for the update.

As soon as I get a version with fixes, I will continue my program upgrade. The next round of conversions on my part will be the REAL test as the problems I found so far have just been SELECT statements used in my reporting backend!

All the best,

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby Aggie85 » Thu 22 Jun 2017 06:29

Howdy Maxim!

I know it has only been a few days.

Do y'all have an approximate ETA for the next release?

I need to determine if I wait or move on to my next major thing and come back to my current task.

Thanks again!

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby Aggie85 » Tue 27 Jun 2017 16:37

Come-on Max!

At least throw me a bone (update)!

Thanks,

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby MaximG » Thu 29 Jun 2017 08:31

We carefully investigated the problem according to your description. We fixed VirtualDAC behavior. The fix will be included in the next VirtualDAC build. Currently, we can send you a night build that includes this fix. For this, provide your license number and the version of Delphi you are interested in using the e-support form (https://www.devart.com the "Support" \ "Request Support" menu)
MaximG
Devart Team
 
Posts: 740
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualQuery

Postby Aggie85 » Thu 29 Jun 2017 16:30

Howdy Maxim!

I sent the email with my license info again for latest update.

Does this fix also fix the slow data retrieval on joined statements?

Thanks for the great support.

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby MaximG » Fri 30 Jun 2017 14:31

You are absolutely right, this fix includes our changes aimed at increasing VirtualQuery performance when using the JOIN statement in a query
MaximG
Devart Team
 
Posts: 740
Joined: Mon 06 Jul 2015 11:34

Re: TVirtualQuery

Postby Aggie85 » Fri 30 Jun 2017 15:57

Howdy Maxim!

Thanks for the great NEWS and SUPPORT!

As soon as I get the latest nightly build, I am going to repeat my regression testing and then continue replacing TxQuery in non-readonly areas of my application.

As soon as I get it all working, I will see if I can help you sell a few copies of TVirtualDAC as many of us have been looking for such a component for a LONG time.

Have a great weekend,

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Re: TVirtualQuery

Postby Aggie85 » Mon 03 Jul 2017 20:56

Hey Maxim!

I have emailed y'all since Thursday looking for the "nightly" build!

Any chance of getting it sooner than later?

Thanks,

Aggie85
Aggie85
 
Posts: 66
Joined: Wed 11 Nov 2015 17:03

Next

Return to VirtualDAC