Slow paging problem, urgent! !! !! !! !! !! !! !!

hushujian

Purpose: The existing system uses the Oracle database, and the program must import the data in the SqlServer database. When synchronizing, it is distinguished by X_ID. If the Oracle database exists, it does not need to be imported.

I implemented it this way: I used two Datasets to store Oracle data and SQLServer data, and then used a For loop to determine whether the A_ID in SqlServer exists in Oracle. If it exists, I deleted it from the DataSet, and finally got the recordset to be imported.

The problem is: because the data set in the resulting DataSet is very large, there are thousands, so paging in the DataGrid is particularly slow!

Please master how to deal with it?

hawk1979

Pagination in DataGrid?

Isn't the lz program imported automatically? Want to choose manually?

dydcool

If you take advantage of the paging function that comes with Grid, thousands of pieces of data are unlikely to be much slower, unless you have problems with SQL statements, you can first run your SQL statements on the query analyzer to see the running time , Make another judgment, or you check your code and optimize it.

hushujian

hawk1979:
I used the aspnetpage control, but I changed it and passed the DataSet directly, which is equivalent to paging directly in the Datagrid
To manually select records that are not to be imported

hushujian

dydcool
Paginated is the DataSet

hawk1979

If it is just to guide the data, why do you want to paginate?
Am I understanding the wrong code?

hushujian

It is imported data, but it must be displayed to the user first, and you can choose not to import records.

terrorlin

In fact, I think you should connect the two databases as a database, so that you can directly use the SQL statement to filter and import. For specific operations, look online. Haha, I haven't tried it. . .

hushujian

One is sqlserver and the other is how to interconnect Oracle?