×
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
5 years 10 months 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|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
Less
More
- Posts: 1106
- Thank you received: 148
5 years 10 months ago - 5 years 10 months 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: 5 years 10 months 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
5 years 9 months 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|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
Less
More
- Posts: 1106
- Thank you received: 148
5 years 9 months 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
Less
More
- Posts: 15
- Thank you received: 2
5 years 9 months 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.117 seconds