Which of the following methods is the most efficient to operate Mssql in php in windows? Few articles in this regard generally refer to the use of mssql_connect. some people use the com method to call ado. some people use the adodb PHP class to have pdo. it is useless. if we only consider efficiency, we do not consider universality, which of the following is the most efficient method? 2803 I will discuss how to operate Mssql in php in windows. which method is the most efficient?
There are few articles in this regard
Mssql_connect is generally used.
Someone uses com to call ado
Someone uses the adodb class
With pdo in PHP, it has never been used.
Which of the following is the most efficient?
------ Solution --------------------
28039577,4804620, and LZ. you can also go there to communicate with us .........
By the way, take points, if LZ doesn't mind, you can give more ......
------ Solution --------------------
I personally think mssql_connect should be better, because it is a dedicated function database.
To use odbc for ado, there should be an additional data layer
Adodb has never been used, maybe it is also called odbc
Pdo has never been used!
------ Solution --------------------
You can analyze the source code of adodb, which is available on sf.net.
------ Solution --------------------
Mssql_connect is better.
------ Solution --------------------
Mssql_connect is not clear
However
Related tests for mysql
Pdo is currently used by many people... Adodb is a veteran ....
------ Solution --------------------
You haven't even connected to mssql, and you have always been connected to. net.
------ Solution --------------------
Mssql_connect
This method is used for the company's hundreds of rows.
In addition, during mssql query, you should not use super-large SQL statement statements or dynamic statement combinations, the server's internal storage will not be released. this is a problem with mssql server!
------ Solution --------------------
If you only consider the speed, of course it is mssql_connect.
Upstairs, if you use MSSQL to write complex and complex statements in the code, what is the significance? you need to know that MSSQL has stored procedures.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
