Where is max queryspeed solution for mssql programing?

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.


azsd,2004 4 19
Who is Participating?
arbertConnect With a Mentor Commented:
The original DBLibrary API was the api that you could code for "direct access".  However, the support of this API is going away...
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?
azsdAuthor Commented:
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"
azsdAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.