Sorry forgot to mention that there's no field with account number, it's just a part of @ID. Isn't @ID a primary index itself?
On Friday, 31 July 2020 17:15:36 UTC+2, VK wrote: > > 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/ef1a5fa4-6e7d-498d-8c2a-b501af233ca5o%40googlegroups.com.