Search found 6 matches

by r2d2
09.02.2008, 16:36
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Multithreaded Insert
Replies: 10
Views: 1786

Hello,

I got it. The TransactIsolationLevel of ZCon was not set properly.

Many thanks for all who contributed here!!!

Andreas
by r2d2
09.02.2008, 12:32
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Multithreaded Insert
Replies: 10
Views: 1786

The app has the following db design: Main: TZCon1->TZQuery1->TDataSource->DBGrid it issues threads with the following structure Threadn: TZCon2->TZQuery2->insert/update/... While running the threads work but Main doesnt update. After close and restart of Main I get all records displayed in DBGrid. I...
by r2d2
09.02.2008, 11:31
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Multithreaded Insert
Replies: 10
Views: 1786

Hi,

That worked perfect! Thx!

But now my dbgrid from the main app doesnt update. It uses
a different connection.

Any idea how to get this updated?

Thx
Andreas
by r2d2
08.02.2008, 12:17
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Multithreaded Insert
Replies: 10
Views: 1786

Hi Sandeep,

would it also work to do a connection.create() and a
freeandnil(connection) in each thread?

Thx
Andreas
by r2d2
08.02.2008, 10:39
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Multithreaded Insert
Replies: 10
Views: 1786

Thanks for the quick answer!

Can u give me a example?

Thx
Andreas
by r2d2
08.02.2008, 09:37
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Multithreaded Insert
Replies: 10
Views: 1786

Multithreaded Insert

Hello, I want to change my application to run multithreaded. Right now I am using zeos and firebird. It inserts data sets in a sequential way into database. In general this could be done in parallel. But I wonder if zeos supports this? Sequence: Insert; dataset.fieldbyname('xxx')=xxx; post; How can ...