SDAC abilities

trayal · Post by **trayal** » Wed 01 Jun 2005 12:29

I have 2 questions.

1) Program in folder SDAC\Demos\Performance.
I run "Fetch Test" between SDAC and dbExpress. By result, dbExpress is more faster, than SDAC, though SDAC is special components to access to MSSQL! Why?

2) From MSDN:

SQLOLEDB implements the provider-specific IRowsetFastLoad interface to expose support for Microsoft® SQL Server™ 2000 bulk copy from a consumer to a SQL Server 2000 table

How this interface implements in SDAC?
Can I do somehow bulk-copy operations, using SDAC?

Ikar · Post by **Ikar** » Thu 02 Jun 2005 11:04

> 1) Program in folder SDAC\Demos\Performance.

DbExpress doesn't ask for interfaces related with update data. It allows to increase a little a speed of opening DataSet due to refuse from automat generating UpdateSQL.

> 2) Can I do somehow bulk-copy operations, using SDAC?

SDAC doesn't provide this functionality.

trayal · Post by **trayal** » Thu 02 Jun 2005 12:19

Thanks.

DbExpress doesn't ask ...

Can I disable "ask for interfaces related with update data"?

Ikar · Post by **Ikar** » Fri 03 Jun 2005 07:48

Now it is unlikely possible, but we will consider adding this feature at the next versions.

However, does it make sense insignificant performance increase to refuse from using automatic generating queries for Post and RefreshRecord?

trayal · Post by **trayal** » Fri 03 Jun 2005 08:30

In some cases, I not need automatic generating queries, but I will use any, even insignificant, possibility to performance increase.

Sorry for my english

trayal · Post by **trayal** » Sat 04 Jun 2005 07:00

Sorry.
Not "I will use": I want use any, even insignificant, possibility to performance increase

Ikar · Post by **Ikar** » Mon 06 Jun 2005 14:08

We'll consider this ides. Probably, proper changes will be available by the beginning of the next month.