Performance issues caused by SQL statements in ASP

xiaoxiao2021-03-06  90

Today, the BUG uploaded by the file in the office management system to be made last time was modified because the performance problem in the ASP caused the Recordset object to shut down, and the result made the data storage failed. For this error, I can only understand this:

After the SQL statement select * from tab_files, then call the AddNew method to add the data to be updated, there is no problem on the surface, when the record is quite a lot of Tab_files table, the Select * from Tab_Files issue is exposed, all selected data will write In the system memory buffer (actual operation is completed by RecordSet), the amount of data taken from the database exceeds the critical value of the buffer can accommodate the critical value, and the final data warehouse will of course fail.

I used a temporary solution: Re-construct a SQL statement, this SQL statement does not return any records, just like opening a blank list, then perform a database update operation.

转载请注明原文地址:https://www.9cbs.com/read-122473.html

New Post(0)