Clarion - SQL Performance

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Performance

Roli

2006-12-25, 7:55 am

Hi,

I have a Multi-DLL-App with a Timer Event in the main application,
which makes a Find (Fetch) for check something (every 10 seconds, and I
make a SQL-access and a TPS-access for testing).

Now, I make a calculation in an other module, the first time the Timer
Event will call, the performance of my SQL access in this other module
will go down (perhaps 5 % or less of the normal access).

if I go to the trace utility, I see, that my program will make an "auto
commit off". I try it with manual LOGOUT/COMMIT, but it will not
running faster.

When I work with TPS, there's NO problem.

Have anyone an idea ?

Thanks, Roli

Sponsored Links