Dear Friends
Please let me know which method is faster to access data from Database.
ADO or ODBC API ?
Thaks in advance
Ravi
Printable View
Dear Friends
Please let me know which method is faster to access data from Database.
ADO or ODBC API ?
Thaks in advance
Ravi
Odbc api is faster than ado
mnmrao
Depends on what data source you are accessing, but for the most part ADO (used in conjuction with OLE DB) is very fast. I have tested the two options you mentioned with MS Access and SQL Server, and in both instances, I find perfomance to be a lot better with ADO. But let's see what others have to say about it...
I agree ODBC is faster