Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.
michaell
About
- Username
- michaell
- Joined
- Visits
- 14
- Last Active
- Roles
- Member
Comments
-
I agree ... once I get a solution in place I'll revisit this to see if I can figure out where the issue actually lies.
-
Don, thanks for your input. I created a DSBFS datasource object pointed to our remote database and so far it is working seamlessly. It's possible the issue I was seeing earlier may have been linked to the MySQL driver we installed to use with the…
-
Thanks Don .. I'll look into that. I wasn't trying to imply that SRP_Com() was the problem :) . Just that there seemed to be an issue with MySQL and ADO not working well together with these datatypes. Our code used OLEDB connectors and XOInstance…
-
Not quite Don. Our queries work fine using the HeidiSQL interface. The query using the datetime field in the where clause takes about 18 seconds in HeidiSQL and anywhere from 50 seconds to 70 seconds when submitting it via SRP_Com()'s ADO interfac…
-
sure ... MySQL table ID field is the primary index - BigInt ConnectTime field is a datetime field query "select field1, field2, Cast(ConnectTime as char) as ConnectTime2 where Cast(ConnectTime as date) = '2023-04-22' if we do not cast the datet…
-
Thank you fellas! So after adding the Release command it WOULD have worked if I used the correct syntax in the command :) .... over 10,000 records now and no further memory usage. much appreciated!
-
Thanks Kevin, I did add that 'Release' command for the recordset, but not for the connection object. I'll try that now.
-
so at the end of (inside of) the loop we put ... SRP_Com(obj_recordset, 'Release') .. which didn't help the memory usage, i just added ... obj_recordset = '' ... which also did not help :) .... argh ...