In an RDBMS yes, on jBASE (MV platforms) you have to create an index. Sent from my iPhone
> On Aug 1, 2020, at 8:51 AM, VK <kzm...@gmail.com> wrote: > > > 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. -- -- 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/E4D147D8-A283-4BDE-A336-EE086F6E7BC2%40gmail.com.