× 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

More
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

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
5 years 10 months ago - 5 years 10 months ago #21780 by 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?

Cheers
VK
Last edit: 5 years 10 months ago by VK.

Please Log in or Create an account to join the conversation.

More
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.

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus|G09-G13 TAFC|R05-R23 TAFJ|R19,R23-test
More
5 years 9 months ago #21786 by 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...

Cheers
VK

Please Log in or Create an account to join the conversation.

More
5 years 9 months ago #21791 by darthadhi
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

Valar Dohaeris

Please Log in or Create an account to join the conversation.

Time to create page: 0.117 seconds