Does anyone met pb9 datawindw retrieval speed problem-CodePudding

Pb9 development program, the same program under xp datawindw dw_1. Retrieve (ls_1), fast, to the Windows 7 64 - bit under extremely slowly, data too much or too slow, some people met, the database is ms SQL server 2000

CodePudding user response:

feel winxp is to retrieve back to the data, under the Windows 7 is equivalent to retrieve all the data and then filter back to the data you want at the same pace as

CodePudding user response:

reference 1st floor u014724875 response:

feel winxp is to retrieve back to the data, under the Windows 7 is equivalent to retrieve all the data and then filter back to the data you want at the same pace as

This writing has to do with you, in addition to have a look at whether to use when retrieving the index

CodePudding user response:

The same procedure, the same code
The database is ms SQL 2000
Retrieval speed quickly under winxp
Windows 7 are slow down

CodePudding user response:

reference u014724875 reply: 3/f

the same programs, the same code
The database is ms SQL 2000
Retrieval speed quickly under winxp
Windows 7 are slow down

Haven't met, it is possible that Windows 7 support for sqlserver2000 is not good

CodePudding user response:

Machine performance problem of the same machine Windows 7 system takes up more resources

CodePudding user response:

reference 4 floor lzp_lrp response:

Quote: reference u014724875 reply: 3/f

The same procedure, the same code
The database is ms SQL 2000
Retrieval speed quickly under winxp
Windows 7 are slow down

Haven't met, it is possible that Windows 7 is not good for sqlserver2000 support

To upgrade the SQL version a try,

CodePudding user response:

Windows 7 system problem! I have been using 64 - bit, any MSSQL version is normal

CodePudding user response:

Encountered a similar situation two two projects (different), it is, sql2000 database version is installed,

Solution: disable ipv6 (to remove the front checked), after the restart, retrieve is normal, the individual concluded that older versions of sql2000, with

Windows 7 after the use of ipv6 conflicts