| Subject | Re: [firebird-support] Aborting isc_dsql_execute calls from another thread (Win32) |
|---|---|
| Author | Richard Wesley |
| Post date | 2006-03-23T00:08:43Z |
On Mar 22, 2006, at 13:52, Richard Wesley wrote:
- Execute takes little time, but the first call to Fetch is very
time-consuming.
- Calling Rollback with an active Fetch produces an error.
It seems very odd to me that I cannot abort transactions but only
orphan them. Is this how the server handles this? (I am using the
embedded server FWIW).
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com
> I guess the question is "Where is all the time spent executing a slowPoking around I find:
> query"? I had assumed that all Fetch did was read a data stream that
> had already been created. Is that not the case?
- Execute takes little time, but the first call to Fetch is very
time-consuming.
- Calling Rollback with an active Fetch produces an error.
It seems very odd to me that I cannot abort transactions but only
orphan them. Is this how the server handles this? (I am using the
embedded server FWIW).
________________________________________________________
Richard Wesley Software Engineer
Tableau Software
http://www.tableausoftware.com/ hawkfish
tableausoftware com