SELECT of records in range

  • VK
  • VK's Avatar Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 752
  • Thank you received: 108

VK created the topic: SELECT of records in range

Hi
What is the fastest way to SELECT a set of records from a J4 table?

@IDs are in the format: (account_number)-(date_in_internal_format), e.g. 5001-18628.

trying:

SELECT THE.TABLE WITH @ID BETWEEN "5001-18628" "5001-23012"

Result is bit more than a second (Windows 2019 server, enough memory and CPUs). Maybe it can be improved?

usr: 1.11 sys: 0.00 elapsed: 0m1.11s

Usage of "GE ... LE" didn't help:

usr: 1.36 sys: 0.00 elapsed: 0m1.36s

Records number: circa 340,000.

Resizing didn't help.
Conversion to JR, as expected, made things a bit worse.

Thought about year-based distribution but haven't given it a try yet.

Cheers
VK
#22854

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

Time to create page: 0.605 seconds