SELECT of records in range
- VK
- Topic Author
- Offline
- Platinum Member
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1182
- Thank you received: 157
4 years 4 months ago #22854
by VK
Cheers
VK
SELECT of records in range was created by VK
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.
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
Please Log in or Create an account to join the conversation.
Time to create page: 0.070 seconds