azsd
asked on
Where is max queryspeed solution for mssql programing?
Hi,All
I use Delphi (KOL) with mssql and mysql,
use mysql's libmySQL.dll I can fetch 10,000 rows [id(int),cphone(varchar 16)] into arrays in 0.4s
use ole db and ms sql the first time is 1.3s,
I am crazy at these timing,
My Question are:
Is ms sql offered some libarary like libmysql?
Or any other faster method than MS OLE DB provider?
I just want test if ms sql can't faster or equa to mysql,
I must thansform some apps from mssql to mysql.
Thx.
azsd,2004 4 19
I use Delphi (KOL) with mssql and mysql,
use mysql's libmySQL.dll I can fetch 10,000 rows [id(int),cphone(varchar 16)] into arrays in 0.4s
use ole db and ms sql the first time is 1.3s,
I am crazy at these timing,
My Question are:
Is ms sql offered some libarary like libmysql?
Or any other faster method than MS OLE DB provider?
I just want test if ms sql can't faster or equa to mysql,
I must thansform some apps from mssql to mysql.
Thx.
azsd,2004 4 19
What version of Delphi? Last I knew, only the Enterprise Edition would let you configure a native connection.
Have you also tried ADO and the getrows method to retrieve the same data into an array?
ASKER
To arbert:
thx your reply,
I use pure API to maked the test.
I havn't test the ado's speed because I must package them api to a class to use,
In my province experiences,
ado would be half slower than oledb,en,ODBC is the slowest I meet.
It's to late i gona sleep,I think I must try to search more docs for "is their ms offered `Libmssql` api"
:)
thx your reply,
I use pure API to maked the test.
I havn't test the ado's speed because I must package them api to a class to use,
In my province experiences,
ado would be half slower than oledb,en,ODBC is the slowest I meet.
It's to late i gona sleep,I think I must try to search more docs for "is their ms offered `Libmssql` api"
:)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
yes,right now I founded it at
MSDN Home > MSDN Library > Enterprise Development > Windows Server System > Microsoft SQL Server > Microsoft SQL Server 2000 > Building SQL Server Applications > Programming DB-Library for C
MSDN Home > MSDN Library > Enterprise Development > Windows Server System > Microsoft SQL Server > Microsoft SQL Server 2000 > Building SQL Server Applications > Programming DB-Library for C