× 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

  • Posts: 5
  • Thank you received: 0

Five created the topic: tafc+oracle select very slow

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
#21777

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 555
  • Karma: 10
  • Thank you received: 80

VK replied the 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
#21780

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

  • Posts: 5
  • Thank you received: 0

Five replied the topic: tafc+oracle select very slow

yes, TAFC and Oracle on the same machine.
all select very slow.
ODBC slow too.
#21785

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

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 555
  • Karma: 10
  • Thank you received: 80

VK replied the 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
#21786

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

  • Posts: 14
  • Karma: -1
  • Thank you received: 1

darthadhi replied the topic: tafc+oracle select very slow


Valar Dohaeris
#21791

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

Time to create page: 0.221 seconds