Solved

Where is max queryspeed solution for mssql programing?

Posted on 2004-04-18
5
576 Views
Last Modified: 2010-08-05
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
0
Comment
Question by:azsd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 10853930
What version of Delphi?  Last I knew, only the Enterprise Edition would let you configure a native connection.
0
 
LVL 34

Expert Comment

by:arbert
ID: 10853931
Have you also tried ADO and the getrows method to retrieve the same data into an array?
0
 

Author Comment

by:azsd
ID: 10854173
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"
:)
0
 
LVL 34

Accepted Solution

by:
arbert earned 150 total points
ID: 10855042
The original DBLibrary API was the api that you could code for "direct access".  However, the support of this API is going away...
0
 

Author Comment

by:azsd
ID: 10855937
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
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question