Page 1 of 1
SDAC abilities
Posted: Wed 01 Jun 2005 12:29
by trayal
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?
Posted: Thu 02 Jun 2005 11:04
by Ikar
> 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.
Posted: Thu 02 Jun 2005 12:19
by trayal
Thanks.
DbExpress doesn't ask ...
Can I disable "ask for interfaces related with update data"?
Posted: Fri 03 Jun 2005 07:48
by Ikar
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?
Posted: Fri 03 Jun 2005 08:30
by trayal
In some cases, I not need automatic generating queries, but I will use any, even insignificant, possibility to performance increase.
Sorry for my english
Posted: Sat 04 Jun 2005 07:00
by trayal
Sorry.
Not "I will use": I want use any, even insignificant, possibility to performance increase
Posted: Mon 06 Jun 2005 14:08
by Ikar
We'll consider this ides. Probably, proper changes will be available by the beginning of the next month.