Subject Re: [firebird-support] hung on isc_commit_retaining
Author Dimitry Sibiryakov
> When I run "SELECT * FROM table1", in my machine (XP) it tooks about 2 minutes to execute
> the query before i can make the first fetch, but in Win Vista, app gets hung and also
> Vista begin to function slowly until I terminate the process.

You must do something really wrong to cause this query to run 2
minutes. Show us connection string and the query's plan.

> What should I do? Do fetches and call isc_rollback_retaining? Is always needed to start a
> transaction?

Do "hard commit". Yes, transactions is always needed.