2017. 12. 12. 17:34 keltezéssel, Adriano dos Santos Fernandes írta:
Can you make this leaks using only ISQL?
1) Running the SELECT statement one after another
If run the next SELECT 5 times I get the below stats.
SQL> SELECT * FROM TABLE1 ORDER BY
(CAST(SUBSTRING(TABLE1.TEXT_BLOB_FIELD FROM 1 FOR 40) AS VARCHAR(40)));
1.
Current memory = 12393640
Delta memory = 1621344
Max memory = 14695168
Elapsed time= 2.888 sec
Cpu = 0.220 sec
Buffers = 2048
Reads = 199
Writes = 0
Fetches = 35646
2.
Current memory = 12540352
Delta memory = 146712
Max memory = 14984312
Elapsed time= 3.052 sec
Cpu = 0.190 sec
Buffers = 2048
Reads = 0
Writes = 0
Fetches = 35380
3.
Current memory = 12540352
Delta memory = 0
Max memory = 15133880
Elapsed time= 3.095 sec
Cpu = 0.250 sec
Buffers = 2048
Reads = 0
Writes = 0
Fetches = 35380
For 4. and 5. *memory and Fetches are same with 3.
So, I think no, but don't know how ISQL handle transactions, etc.
My application use only one transaction (read_committed rec_version wait
read), start before run the SELECT statements and commit after.
or
2) Creating a EXECUTE BLOCK with a CURSOR
Can you provide this with the above SELECT?
Gabor
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
