Results 1 to 9 of 9

Thread: cSQLHandleManager - adding to an Array at GET SQLFETCH takes WAY too long

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Feb 2009
    Location
    Sun Valley ID USA
    Posts
    514

    Default cSQLHandleManager - adding to an Array at GET SQLFETCH takes WAY too long

    [VDF 19.1 w/MySQL 8.0 and ODBC 6.x] Using the method attached/below with a fairly complex SELECT Statement and two files having 28M records I can return 52k records in 4 seconds when I comment out the bolded code that adds to the array. However, I need to grab the id's of records found for a subsequent archive process: When I uncomment that bolded code and add 52k record id's to the array it takes 1140 seconds (=19 min, which is too long). Any input you have on how to do this WAY more efficiently is most appreciated

    Click image for larger version. 

Name:	Screenshot 2021-03-01 073934.jpg 
Views:	107 
Size:	102.9 KB 
ID:	14350
    Last edited by Jim Mulenos; 1-Mar-2021 at 09:41 AM. Reason: code snip did not format correctly (indents)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •