| Subject | SP running two times !!! |
|---|---|
| Author | Burak ÖZLER |
| Post date | 2002-02-14T07:44:35Z |
Hi All,
I'm using D5 and IB Native Fl The stiation is I'm calling two SP's
before delete of a TIB_Query component. But It works TWO times and I get an
err msg from my SP naturally. I work for a night to find the problem but I
can't.
I'm calling Commitretaining onafterdelete Maybe this helps...
I have running time problem with IBO; Jason any solution for the
CalculateAllFields property?
Here are the SQL statements that I monitor when deleting...
/*===
PROFILE DIFF REPORT -- Before execute2 dsql
*** OVERALL SERVER PROCESS ***
Current Memory = 9.886.680 (-8.192)
Num Buffer Reads = 43.592 (+5)
Num Buffer Writes = 702 (+5)
Num Page Writes = 277 (+5)
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 15620792
STMT_HANDLE = 15619000
PARAMS = [ Version 1 SQLd 13 SQLn 13
[CHBELGETURID] = 4
[CHBELGEID] = 91
[CHBELGE_SID] = 1
[CHCARIID] = 145
[CHCARI_SID] = 1
[CHTIP] = 0
[CHTARIH] = '14 Şub 2002'
[CHDOVKOD] = 'USD '
[CHTUTAR] = 5000
[CHVADETAR] = '14 Şub 2002'
[CHACIKLAMA] = 'rfgertwe'
[CHGR] = 0
[CHSIL] = 1 ]
FIELDS = [ Version 1 SQLd 5 SQLn 5
CARIHAR_AUD.PRCARIHARID = 92
CARIHAR_AUD.PRCARIHAR_SID = 1
CARIHAR_AUD.PRLIMITASIMI = 0
CARIHAR_AUD.PROLDU = 1
CARIHAR_AUD.NEDEN = '' ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After execute2 dsql
*** OVERALL SERVER PROCESS ***
Current Memory = 9.891.800 (+5.120)
Num Buffer Reads = 44.556 (+964)
Num Buffer Writes = 727 (+25)
Num Page Writes = 286 (+9)
*** SEQUENTIAL (NON-INDEXED) READS *** 125
113 RDB$INDICES
12 DOVKART
*** INDEXED READS *** 41
10 DOVKUR
12 PARAMETERS
2 CARI
3 CARIHAR
2 CARI_AY
4 CARI_AY_DOV
4 CARIHAR_DOV
4 CARI_DOV
*** INSERT COUNT *** 2
2 CARIHAR_DOV
*** UPDATE COUNT *** 6
1 CARI
1 CARI_AY
2 CARI_AY_DOV
2 CARI_DOV
*** DELETE COUNT *** 5
1 CARIHAR
4 CARIHAR_DOV
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute2 dsql
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 15620792
STMT_HANDLE = 15614412
PARAMS = [ Version 1 SQLd 11 SQLn 11
[BELGETURID] = 4
[BELGEID] = 91
[BELGE_SID] = 1
[BHESAPID] = 20
[BHESAP_SID] = 1
[TARIH] = '14 Şub 2002'
[TIP] = 1
[DOVKOD] = 'USD '
[TUTAR] = 5000
[GR] = 0
[SIL] = 1 ]
FIELDS = [ Version 1 SQLd 3 SQLn 3
BANKAHAR_AUD.BANKAHAR_ID = 19
BANKAHAR_AUD.BANKAHAR_SID = 1
BANKAHAR_AUD.OLDU = 1 ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After execute2 dsql
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.275 (+719)
Num Buffer Writes = 730 (+3)
Num Page Writes = 288 (+2)
*** SEQUENTIAL (NON-INDEXED) READS *** 113
113 RDB$INDICES
*** INDEXED READS *** 5
2 BANKAHESAP
3 BANKAHAR
*** UPDATE COUNT *** 1
1 BANKAHESAP
*** DELETE COUNT *** 1
1 BANKAHAR
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620792
STMT_HANDLE = 15619260
DELETE FROM CEK
WHERE CEK.CEKID = ? /* OLD.CEKID */
AND CEK.CEK_SID = ? /* OLD.CEK_SID */
PLAN (CEK INDEX (RDB$PRIMARY11))
FIELDS = [ Version 1 SQLd 0 SQLn 30 ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Current Memory = 9.894.872 (+3.072)
Num Buffer Reads = 45.282 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620792
STMT_HANDLE = 15619260
PARAMS = [ Version 1 SQLd 2 SQLn 2
CEK.CEKID[CEKID] = 91
CEK.CEK_SID[CEK_SID] = 1 ]
SELECT COUNT: 1
DELETE COUNT: 1
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.289 (+7)
Num Buffer Writes = 731 (+1)
Num Page Writes = 289 (+1)
*** INDEXED READS *** 1
1 CEK
*** DELETE COUNT *** 1
1 CEK
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before start transaction
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
*** OVERALL SERVER PROCESS ***
Current Memory = 9.895.896 (+1.024)
Num Buffer Reads = 45.290 (+1)
Num Buffer Writes = 732 (+1)
Num Page Writes = 290 (+1)
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select CARIAD
, CARI.RDB$DB_KEY
From CARI Where CARIID=0 And CARI_SID=0
PLAN (CARI INDEX (RDB$PRIMARY4))
FIELDS = [ Version 1 SQLd 2 SQLn 30
CARI.CARIAD = <NIL>
CARI.DB_KEY = <NIL> ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.297 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.299 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select AD
, BANKA.RDB$DB_KEY
From BANKA Where BANKAID=0 And BANKA_SID=0
PLAN (BANKA INDEX (RDB$PRIMARY1))
FIELDS = [ Version 1 SQLd 2 SQLn 30
BANKA.AD = <NIL>
BANKA.DB_KEY = <NIL> ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.306 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Current Memory = 9.896.920 (+1.024)
Num Buffer Reads = 45.308 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select HESAPNO, DOVKOD
, BANKAHESAP.RDB$DB_KEY
From BANKAHESAP Where BHESAPID=0 And BHESAP_SID=0
PLAN (BANKAHESAP INDEX (RDB$PRIMARY2))
FIELDS = [ Version 1 SQLd 3 SQLn 30
BANKAHESAP.HESAPNO = <NIL>
BANKAHESAP.DOVKOD = <NIL>
BANKAHESAP.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.315 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.317 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select CARIAD
, CARI.RDB$DB_KEY
From CARI Where CARIID=0 And CARI_SID=0
PLAN (CARI INDEX (RDB$PRIMARY4))
FIELDS = [ Version 1 SQLd 2 SQLn 30
CARI.CARIAD = <NIL>
CARI.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.324 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.326 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select AD
, BANKA.RDB$DB_KEY
From BANKA Where BANKAID=0 And BANKA_SID=0
PLAN (BANKA INDEX (RDB$PRIMARY1))
FIELDS = [ Version 1 SQLd 2 SQLn 30
BANKA.AD = <NIL>
BANKA.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.333 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.335 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select HESAPNO, DOVKOD
, BANKAHESAP.RDB$DB_KEY
From BANKAHESAP Where BHESAPID=0 And BHESAP_SID=0
PLAN (BANKAHESAP INDEX (RDB$PRIMARY2))
FIELDS = [ Version 1 SQLd 3 SQLn 30
BANKAHESAP.HESAPNO = <NIL>
BANKAHESAP.DOVKOD = <NIL>
BANKAHESAP.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.342 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.344 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select CARIAD
, CARI.RDB$DB_KEY
From CARI Where CARIID=0 And CARI_SID=0
PLAN (CARI INDEX (RDB$PRIMARY4))
FIELDS = [ Version 1 SQLd 2 SQLn 30
CARI.CARIAD = <NIL>
CARI.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.351 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.353 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select AD
, BANKA.RDB$DB_KEY
From BANKA Where BANKAID=0 And BANKA_SID=0
PLAN (BANKA INDEX (RDB$PRIMARY1))
FIELDS = [ Version 1 SQLd 2 SQLn 30
BANKA.AD = <NIL>
BANKA.DB_KEY = <NIL> ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.360 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.362 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select HESAPNO, DOVKOD
, BANKAHESAP.RDB$DB_KEY
From BANKAHESAP Where BHESAPID=0 And BHESAP_SID=0
PLAN (BANKAHESAP INDEX (RDB$PRIMARY2))
FIELDS = [ Version 1 SQLd 3 SQLn 30
BANKAHESAP.HESAPNO = <NIL>
BANKAHESAP.DOVKOD = <NIL>
BANKAHESAP.DB_KEY = <NIL> ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.369 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.371 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute2 dsql
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 15620792
STMT_HANDLE = 15619000
PARAMS = [ Version 1 SQLd 13 SQLn 13
[CHBELGETURID] = 4
[CHBELGEID] = 0
[CHBELGE_SID] = 0
[CHCARIID] = 0
[CHCARI_SID] = 0
[CHTIP] = 0
[CHTARIH] = '30 Ara 1899'
[CHDOVKOD] = ' '
[CHTUTAR] = 0
[CHVADETAR] = '30 Ara 1899'
[CHACIKLAMA] = ''
[CHGR] = 0
[CHSIL] = 0 ]
FIELDS = [ Version 1 SQLd 5 SQLn 5
CARIHAR_AUD.PRCARIHARID = 93
CARIHAR_AUD.PRCARIHAR_SID = 1
CARIHAR_AUD.PRLIMITASIMI = 0
CARIHAR_AUD.PROLDU = 1
CARIHAR_AUD.NEDEN = ' GETDOVIZKUR:30/12/1899 Tarihine Ait kur
bilgisi bulunamadi KURDONUSTUR: Donusturulen kur 0 dondugunden ya da kuru
bulunamadigindan islem yapilamadi' ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After execute2 dsql
*** OVERALL SERVER PROCESS ***
Current Memory = 9.897.944 (+1.024)
Num Buffer Reads = 45.472 (+101)
Num Buffer Writes = 741 (+9)
Num Page Writes = 294 (+4)
*** SEQUENTIAL (NON-INDEXED) READS *** 2
2 DOVKART
*** INDEXED READS *** 12
12 PARAMETERS
*** INSERT COUNT *** 1
1 CARIHAR
PROFILE DATA MARKED AS START
====*/
I'm using D5 and IB Native Fl The stiation is I'm calling two SP's
before delete of a TIB_Query component. But It works TWO times and I get an
err msg from my SP naturally. I work for a night to find the problem but I
can't.
I'm calling Commitretaining onafterdelete Maybe this helps...
I have running time problem with IBO; Jason any solution for the
CalculateAllFields property?
Here are the SQL statements that I monitor when deleting...
/*===
PROFILE DIFF REPORT -- Before execute2 dsql
*** OVERALL SERVER PROCESS ***
Current Memory = 9.886.680 (-8.192)
Num Buffer Reads = 43.592 (+5)
Num Buffer Writes = 702 (+5)
Num Page Writes = 277 (+5)
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 15620792
STMT_HANDLE = 15619000
PARAMS = [ Version 1 SQLd 13 SQLn 13
[CHBELGETURID] = 4
[CHBELGEID] = 91
[CHBELGE_SID] = 1
[CHCARIID] = 145
[CHCARI_SID] = 1
[CHTIP] = 0
[CHTARIH] = '14 Şub 2002'
[CHDOVKOD] = 'USD '
[CHTUTAR] = 5000
[CHVADETAR] = '14 Şub 2002'
[CHACIKLAMA] = 'rfgertwe'
[CHGR] = 0
[CHSIL] = 1 ]
FIELDS = [ Version 1 SQLd 5 SQLn 5
CARIHAR_AUD.PRCARIHARID = 92
CARIHAR_AUD.PRCARIHAR_SID = 1
CARIHAR_AUD.PRLIMITASIMI = 0
CARIHAR_AUD.PROLDU = 1
CARIHAR_AUD.NEDEN = '' ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After execute2 dsql
*** OVERALL SERVER PROCESS ***
Current Memory = 9.891.800 (+5.120)
Num Buffer Reads = 44.556 (+964)
Num Buffer Writes = 727 (+25)
Num Page Writes = 286 (+9)
*** SEQUENTIAL (NON-INDEXED) READS *** 125
113 RDB$INDICES
12 DOVKART
*** INDEXED READS *** 41
10 DOVKUR
12 PARAMETERS
2 CARI
3 CARIHAR
2 CARI_AY
4 CARI_AY_DOV
4 CARIHAR_DOV
4 CARI_DOV
*** INSERT COUNT *** 2
2 CARIHAR_DOV
*** UPDATE COUNT *** 6
1 CARI
1 CARI_AY
2 CARI_AY_DOV
2 CARI_DOV
*** DELETE COUNT *** 5
1 CARIHAR
4 CARIHAR_DOV
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute2 dsql
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 15620792
STMT_HANDLE = 15614412
PARAMS = [ Version 1 SQLd 11 SQLn 11
[BELGETURID] = 4
[BELGEID] = 91
[BELGE_SID] = 1
[BHESAPID] = 20
[BHESAP_SID] = 1
[TARIH] = '14 Şub 2002'
[TIP] = 1
[DOVKOD] = 'USD '
[TUTAR] = 5000
[GR] = 0
[SIL] = 1 ]
FIELDS = [ Version 1 SQLd 3 SQLn 3
BANKAHAR_AUD.BANKAHAR_ID = 19
BANKAHAR_AUD.BANKAHAR_SID = 1
BANKAHAR_AUD.OLDU = 1 ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After execute2 dsql
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.275 (+719)
Num Buffer Writes = 730 (+3)
Num Page Writes = 288 (+2)
*** SEQUENTIAL (NON-INDEXED) READS *** 113
113 RDB$INDICES
*** INDEXED READS *** 5
2 BANKAHESAP
3 BANKAHAR
*** UPDATE COUNT *** 1
1 BANKAHESAP
*** DELETE COUNT *** 1
1 BANKAHAR
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620792
STMT_HANDLE = 15619260
DELETE FROM CEK
WHERE CEK.CEKID = ? /* OLD.CEKID */
AND CEK.CEK_SID = ? /* OLD.CEK_SID */
PLAN (CEK INDEX (RDB$PRIMARY11))
FIELDS = [ Version 1 SQLd 0 SQLn 30 ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Current Memory = 9.894.872 (+3.072)
Num Buffer Reads = 45.282 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620792
STMT_HANDLE = 15619260
PARAMS = [ Version 1 SQLd 2 SQLn 2
CEK.CEKID[CEKID] = 91
CEK.CEK_SID[CEK_SID] = 1 ]
SELECT COUNT: 1
DELETE COUNT: 1
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.289 (+7)
Num Buffer Writes = 731 (+1)
Num Page Writes = 289 (+1)
*** INDEXED READS *** 1
1 CEK
*** DELETE COUNT *** 1
1 CEK
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before start transaction
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
*** OVERALL SERVER PROCESS ***
Current Memory = 9.895.896 (+1.024)
Num Buffer Reads = 45.290 (+1)
Num Buffer Writes = 732 (+1)
Num Page Writes = 290 (+1)
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select CARIAD
, CARI.RDB$DB_KEY
From CARI Where CARIID=0 And CARI_SID=0
PLAN (CARI INDEX (RDB$PRIMARY4))
FIELDS = [ Version 1 SQLd 2 SQLn 30
CARI.CARIAD = <NIL>
CARI.DB_KEY = <NIL> ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.297 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.299 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select AD
, BANKA.RDB$DB_KEY
From BANKA Where BANKAID=0 And BANKA_SID=0
PLAN (BANKA INDEX (RDB$PRIMARY1))
FIELDS = [ Version 1 SQLd 2 SQLn 30
BANKA.AD = <NIL>
BANKA.DB_KEY = <NIL> ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.306 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Current Memory = 9.896.920 (+1.024)
Num Buffer Reads = 45.308 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select HESAPNO, DOVKOD
, BANKAHESAP.RDB$DB_KEY
From BANKAHESAP Where BHESAPID=0 And BHESAP_SID=0
PLAN (BANKAHESAP INDEX (RDB$PRIMARY2))
FIELDS = [ Version 1 SQLd 3 SQLn 30
BANKAHESAP.HESAPNO = <NIL>
BANKAHESAP.DOVKOD = <NIL>
BANKAHESAP.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.315 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.317 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select CARIAD
, CARI.RDB$DB_KEY
From CARI Where CARIID=0 And CARI_SID=0
PLAN (CARI INDEX (RDB$PRIMARY4))
FIELDS = [ Version 1 SQLd 2 SQLn 30
CARI.CARIAD = <NIL>
CARI.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.324 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.326 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select AD
, BANKA.RDB$DB_KEY
From BANKA Where BANKAID=0 And BANKA_SID=0
PLAN (BANKA INDEX (RDB$PRIMARY1))
FIELDS = [ Version 1 SQLd 2 SQLn 30
BANKA.AD = <NIL>
BANKA.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.333 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.335 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select HESAPNO, DOVKOD
, BANKAHESAP.RDB$DB_KEY
From BANKAHESAP Where BHESAPID=0 And BHESAP_SID=0
PLAN (BANKAHESAP INDEX (RDB$PRIMARY2))
FIELDS = [ Version 1 SQLd 3 SQLn 30
BANKAHESAP.HESAPNO = <NIL>
BANKAHESAP.DOVKOD = <NIL>
BANKAHESAP.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.342 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.344 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select CARIAD
, CARI.RDB$DB_KEY
From CARI Where CARIID=0 And CARI_SID=0
PLAN (CARI INDEX (RDB$PRIMARY4))
FIELDS = [ Version 1 SQLd 2 SQLn 30
CARI.CARIAD = <NIL>
CARI.DB_KEY = <NIL> ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.351 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.353 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select AD
, BANKA.RDB$DB_KEY
From BANKA Where BANKAID=0 And BANKA_SID=0
PLAN (BANKA INDEX (RDB$PRIMARY1))
FIELDS = [ Version 1 SQLd 2 SQLn 30
BANKA.AD = <NIL>
BANKA.DB_KEY = <NIL> ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.360 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.362 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before prepare
PROFILE DATA MARKED AS START
====*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
Select HESAPNO, DOVKOD
, BANKAHESAP.RDB$DB_KEY
From BANKAHESAP Where BHESAPID=0 And BHESAP_SID=0
PLAN (BANKAHESAP INDEX (RDB$PRIMARY2))
FIELDS = [ Version 1 SQLd 3 SQLn 30
BANKAHESAP.HESAPNO = <NIL>
BANKAHESAP.DOVKOD = <NIL>
BANKAHESAP.DB_KEY = <NIL> ]
----*/
/*===
PROFILE DIFF REPORT -- After prepare
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.369 (+7)
*** INDEXED READS *** 2
2 RDB$INDICES
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE STATEMENT
TR_HANDLE = 15620880
STMT_HANDLE = 15614196
PARAMS = [ ]
----*/
/*===
PROFILE DIFF REPORT -- After execute
*** OVERALL SERVER PROCESS ***
Num Buffer Reads = 45.371 (+2)
PROFILE DATA MARKED AS START
====*/
/*===
PROFILE DIFF REPORT -- Before execute2 dsql
PROFILE DATA MARKED AS START
====*/
/*---
EXECUTE2 DSQL
TR_HANDLE = 15620792
STMT_HANDLE = 15619000
PARAMS = [ Version 1 SQLd 13 SQLn 13
[CHBELGETURID] = 4
[CHBELGEID] = 0
[CHBELGE_SID] = 0
[CHCARIID] = 0
[CHCARI_SID] = 0
[CHTIP] = 0
[CHTARIH] = '30 Ara 1899'
[CHDOVKOD] = ' '
[CHTUTAR] = 0
[CHVADETAR] = '30 Ara 1899'
[CHACIKLAMA] = ''
[CHGR] = 0
[CHSIL] = 0 ]
FIELDS = [ Version 1 SQLd 5 SQLn 5
CARIHAR_AUD.PRCARIHARID = 93
CARIHAR_AUD.PRCARIHAR_SID = 1
CARIHAR_AUD.PRLIMITASIMI = 0
CARIHAR_AUD.PROLDU = 1
CARIHAR_AUD.NEDEN = ' GETDOVIZKUR:30/12/1899 Tarihine Ait kur
bilgisi bulunamadi KURDONUSTUR: Donusturulen kur 0 dondugunden ya da kuru
bulunamadigindan islem yapilamadi' ]
SECONDS = 0,010
----*/
/*===
PROFILE DIFF REPORT -- After execute2 dsql
*** OVERALL SERVER PROCESS ***
Current Memory = 9.897.944 (+1.024)
Num Buffer Reads = 45.472 (+101)
Num Buffer Writes = 741 (+9)
Num Page Writes = 294 (+4)
*** SEQUENTIAL (NON-INDEXED) READS *** 2
2 DOVKART
*** INDEXED READS *** 12
12 PARAMETERS
*** INSERT COUNT *** 1
1 CARIHAR
PROFILE DATA MARKED AS START
====*/