Steve

I think Raul's suggestion is a good one. Essentially its what I did to find my testbed for Tim.


Are you doing anything other than standard database operations eg creating / dropping triggers, scripts etc, creating users anything other than standard table read / write? Remember ANYTHING you do with ElevateDB hits the engne so all that's happening is that you're kicking it where you shouldn't!

Since I'm on an antiquated Delphi (D2007) I've never used the Delphi Parallel library so no idea, but the comment does make me wonder what you're doing

When I started using threads I looked at a number of the libraries but found that it was simpler in many cases to simply roll my own using TThread. The ones I looked at added a layer of complexity to something simple and required me to try (and often fail) to understand their logic. Threading problems are almost always caused by stomping on someone else's memory - this can be in your code or someone elses so the simpler you can keep your environment the better.


Roy Lambert

Matthew


Some very good points there. Just to add my bit - you can pass sessions around to some degree. I have several classes that are created in threads which access tables and I pass the thread's session on to them.

Roy Lambert

Roy Lambert wrote:

> you can pass sessions around to some degree

Indeed - you just have to be fully aware of which thread, and what is happening with it. One thing I found with the thread pool was I'd be in the middle of some query, and another thread would nip in and use the same user session data to do another query at the same time. That lead to some interesting results! Switching to keep it simple and self-contained solved it all.

--

Matthew Jones

Steve,

<< Thanks for responding.  I am now talking about it with Tim via email, however if you have used threading with EDB I'd be grateful for any insights or tips you may have. >>

If you want to work up an example project that reproduces what you're seeing, I'll be happy to run it and see what's going on.  You've sent me code so far, but nothing that I can directly run (I'm missing some bits of code here and there).

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

<< If you want to work up an example project that reproduces what you're seeing, I'll be happy to run it and see what's going on.  You've sent me code so far, but nothing that I can directly run (I'm missing some bits of code here and there). >>

Thanks.  I'll try to put one together.

= Steve