Hello Richard,

thanks for your hints! Well appreciated!


Am 02.07.2025 um 23:25 schrieb Richard Schoen <richard@xxxxxxxxxxxxxxxxx>:

Do you know if your developer is using the ADO.Net ODBC connectivity or trying to use Entity Framework ?

No, I don't know. Will ask.

I seem to recall Entity Framework didn’t have a layer for ODBC.

So, Entity Framework is out, because then things would not work at all, I presume?

Also depending on how often they are calling services I wonder if their coding could be inducing the ODBC issues by overloading things.

How could one "overload" things? A CPU can only do so many things, one after the other. If there are more things to do than the CPU can run, idle time goes down to 0, and processing speed for each entity of work decreases.

With today's accepted increase in (IMHO needless) complexity — with the excuse of appearing innovative, "that's the modern way", and other partly ludicrous reasoning — threads and asynchronous programming apparently are state of the art in certain "areas of programming". It's a well known platitude that programming with threads — all running in the same memory area as the parent process — gives rise to all kinds of race conditions and hard to track down timing issues.

Or possibly they are trying to use the same open ODBC connection with multiple threads. That seems like it could cause issues.

In theory, that shouldn't be the case. I'd even expect to reuse open connections, to spare needles resources on frequent new connections to be processed. I know, he's using some built-in connection pooling of the component he uses.

Without seeing their code it’s hard to say.

I guess this is almost off-topic to discuss .NET code in here. :-) But I can ask the programmer if he's willing to privately discuss the issue with you. If you're okay with it.

Also not sure if they are trying connection pooling or not.

As far as I've understood, there are two kinds of connection pools: From the ODBC driver itself, but also by the component he uses in .NET. Don't know more details.

Posting the question here might help as Korinne Adler knows a lot about ODBC, as does Calvin Buckley who hosts the site:
https://chat.ibmioss.org

Thanks, will pass this along.

:wq! PoC



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.