Devart Forums

Hello together,

sometimes I need two instances of a DB. With ADO I made a ADODataset.clone. In Uniquery I can make But the open needs again 18 seconds. Is there a faster way to get a clone from UniQuery1 for example after an insert in UniQuery1?
The long time (18s) is coming from setting the IndexFieldNames to make shure the datas are also sortetd correct after an insert.

Sometimes I need in UniQuery2 only some columns of the table. But UniQuery2 should also be updatetd in a fast way after an insert in UniQuery1. How to do this?

I also tried but this needs longer than an assign with following open

best thanks
Gerd

Hello,

Unfortunately, we didn't implemente the Clone method.
We will investigate the possibility of adding this feature in one of the next builds/versions of UniDAC.
Now you can use only Assign and Open methods to clone datasets.

Is there no way to increase the speed? Especialy as the datas are already on the client and I only need a second view on it.

Hello,

If you need only to view data, you can try to use the following code::

VirtualTable1.Assign(UniQuery1);
VirtualTable1.Open;

This will increase performance a bit.

I found this thread in a Google search.

Please add me to the list of those wanting the Clone method implemented. I am looking to convert an Ado app to Devart and need this functionality for the same reason; I am using a data cache.

I should add that if the feature is added, it should work better than ADO's Clone method. It should work like TClientDataSet's CloneCursor.

Scratch that last comment. I thought TClientDataSet would automatically update cloned datasets when the source was closed and re-opened. ADO and CDS don't. Figured a workaround for each, but CDS takes a long time to cache the data in D2007. ADO is faster.