×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
tafc+oracle select very slow
- Five
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 5
- Thank you received: 0
7 years 1 month ago #21777
by Five
tafc+oracle select very slow was created by Five
aix 7.1
R17 TAFC
oracle 12
ssd
8 cpu
450g ram
why select work very slow???
time SELECT FBNK.ACCOUNT WITH WORKING.BALANCE EQ 100
141 Records selected
usr: 14.87 sys: 3.25 elapsed: 1m16.50s
COUNT FBNK.ACCOUNT
350662 Records counted
R17 TAFC
oracle 12
ssd
8 cpu
450g ram
why select work very slow???
time SELECT FBNK.ACCOUNT WITH WORKING.BALANCE EQ 100
141 Records selected
usr: 14.87 sys: 3.25 elapsed: 1m16.50s
COUNT FBNK.ACCOUNT
350662 Records counted
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1209
- Thank you received: 158
7 years 1 month ago - 7 years 1 month ago #21780
by VK
Cheers
VK
Replied by VK on topic tafc+oracle select very slow
Hi
Is this the only slow SELECT or other tables behave the same?
Is SELECT without criteria also slow?
If you have other possibilities to retrieve data from DB (ODBC etc), try these.. Are they slow as well?
Last but not least: are TAFC and Oracle on the same machine?
Is this the only slow SELECT or other tables behave the same?
Is SELECT without criteria also slow?
If you have other possibilities to retrieve data from DB (ODBC etc), try these.. Are they slow as well?
Last but not least: are TAFC and Oracle on the same machine?
Cheers
VK
Last edit: 7 years 1 month ago by VK.
Please Log in or Create an account to join the conversation.
- Five
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 5
- Thank you received: 0
7 years 1 month ago #21785
by Five
Replied by Five on topic tafc+oracle select very slow
yes, TAFC and Oracle on the same machine.
all select very slow.
ODBC slow too.
all select very slow.
ODBC slow too.
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1209
- Thank you received: 158
7 years 1 month ago #21786
by VK
Cheers
VK
Replied by VK on topic tafc+oracle select very slow
Hi
maybe then it's not directly related to T24? Try to get more info from Oracle...
maybe then it's not directly related to T24? Try to get more info from Oracle...
Cheers
VK
Please Log in or Create an account to join the conversation.
- darthadhi
-
- Offline
- New Member
-
- Temenos Transact(R10 - R22)
Less
More
- Posts: 16
- Thank you received: 2
7 years 1 month ago #21791
by darthadhi
Valar Dohaeris
Replied by darthadhi on topic tafc+oracle select very slow
hi Vk,
please help me out on this issue www.t24all.com/index.php/forum/t24-devel...ile-in-tafj-r17.html
please help me out on this issue www.t24all.com/index.php/forum/t24-devel...ile-in-tafj-r17.html
Valar Dohaeris
Please Log in or Create an account to join the conversation.
Time to create page: 0.042 seconds