I would make the SELECT field specific, ie SELECT WITH ACCOUNT = "5001" AND WITH DATE GT @18628 AND DATE LT 23012
ACCOUNT_NUMBER and DATE are likely to be indexed. It's like having a porsche in the garage but insisting on using your daughter's bicycle to do the speed trial if you insist on using a SELECT on a random ID being between x and y, when you actually have indexed fields you can select on. Dennis Bartlett If you consider that 3000 plus banks used JBase before it moved on, I'd say the case for JBase indexing is solid. On Fri, 31 Jul 2020 at 16:15, VK <kzm...@gmail.com> 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/6dc6a3b5-6d52-4f90-bb32-2f6c7fa8d260o%40googlegroups.com > <https://groups.google.com/d/msgid/jbase/6dc6a3b5-6d52-4f90-bb32-2f6c7fa8d260o%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- -- 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/CAE1D0%2Bgp%3Db3ofGRugdptnUDMhK7ZzfQyz8FaMdN-UuUWDnxWyA%40mail.gmail.com.
