Control the database using the sdac
Query, when a small amount of data is normal, the amount of data query one year about 120000 records in the following error
Delphi three-tier socket query error insufficient memory for this operation
Is there a way to solve

CodePudding user response:

12 w should not, what is your database, directly in the editor will execute the query error

CodePudding user response:

Not right, only then 12 w,

CodePudding user response:

Insufficient memory for this operation
This operation is out of memory,

Suggest you will Tadoconnection. CursorLocation//specified database pointer is pointing to the client or server side
Set to cluseServer: using server-side database pointer, this applies to the large amount of data data sets,