Where is max queryspeed solution for mssql programing?
Posted on 2004-04-18
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