|Subject||Re: [firebird-support] hung on isc_commit_retaining|
> When I run "SELECT * FROM table1", in my machine (XP) it tooks about 2 minutes to executeYou must do something really wrong to cause this query to run 2
> 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.
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 aDo "hard commit". Yes, transactions is always needed.