Hi coleagues. 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. Last question - is jBASE indexing stable enough to be trusted? TAFC 13 (no, question isn't about T24!) -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/jBASE?hl=en --- You received this message because you are subscribed to the Google Groups "jBASE" group. To unsubscribe from this group and stop receiving emails from it, send an email to jbase+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/6dc6a3b5-6d52-4f90-bb32-2f6c7fa8d260o%40googlegroups.com.