Now a program via the Internet is essentially (2 k and 2 k5 effect, and on the same machine, not compile, direct use pb)
Is to perform the following statement:
Cpu1=(CPU)
Select count (*) from the TAB
Cpu2=(CPU) - cpu1

Now using pb9 and pb10 as contrast test, found that using pb9 perform just need around 300 ms
Whereas pb10 use oledb to 1500 ms, is almost 5 times pb9 time
Then use PB10/pb9 + odbc, found that speed is around 500 ms
In theory the oledb is greater than the rate of odbc! But why is reflected in the oledb, slow?
Is the connection configuration problem?


//Profile pb9
The SQLCA. DBMS="MSS Microsoft SQL Server"
The SQLCA. Database="test"
The SQLCA. LogPass=& lt; * * & gt;
The SQLCA. ServerName="server"
The SQLCA. LogId="sa"
The SQLCA. The AutoCommit=False
The SQLCA. DBParm=""

//Profile pb10
The SQLCA. DBMS="OLE DB"
The SQLCA. LogPass=& lt; * * & gt;
The SQLCA. LogId="sa"
The SQLCA. Lock="RC"
The SQLCA. The AutoCommit=False
='SQLOLEDB' SQLCA. DBParm="PROVIDER and DATASOURCE='server', PROVIDERSTRING='database=test, DelimitIdentifier=' No '"

CodePudding user response:

Someone encountered this problem, waiting for solving...

CodePudding user response:

Even used the oledb is supposed to be the best.
Odbc to connect, some pictures and ole way, will go wrong, the oleDB not.

Indicate the port number, after the server can greatly speed up the connection. DelimitIdentifier='No' can be removed

CodePudding user response:

DelimitIdentifier='No' to compatible with ASA, for the sake of speed, put some code table in the local, the drop-down data window can be a lot faster, but thank you teach, first try first

CodePudding user response:

DelimitIdentifier='No' is to remove the "
the ASAI know, but if you just even used, no need to

CodePudding user response:

Coding on local is in the coding content under the condition of fixed, as such, you use XML, file storage local code table, faster. Maintenance is convenient.

Although PB can connect multiple databases at the same time, unless very necessary, however, I suggest you only even a library

CodePudding user response:

After the server after the specified port number, isn't it much faster

CodePudding user response:

As 2nd floor says, OLEDB than ODBC access to more information, look not to come out in the unit, the remote is easy to impact on the speed in favor of,

OLEDB is not suitable for use on the remote network, the building Lord still don't find solution, webService is a good choice

CodePudding user response:

Actually remote, with direct database is highly safe,
The best solution is to use remote solution citrix,
After use, you will find that the so-called C/S and B/S meaningless,
But for large projects, or not applicable, but it is nice to below 500 points for small and medium-sized.

CodePudding user response:

reference 1st floor XLKXHF response:

someone encountered this problem, waiting for the address...

Yesterday tried to add port problems still exist, is there any solution?

CodePudding user response:

The building Lord, I have the same problem. Thought direct connection will be faster than the ODBC. Can also slower.
SNC SQL Native Client is installed, but I can't find the direct code,
With the SQLCA. DBMS="SNC SQL Native Client (the OLEDB)", the tip can't find this DBMS.
Please master action, thank you!