Hi Vishal, I think it will depend on how much min/max memory per query we configure for a database session, so it will depend on the concurrent load of application and hardware capability.
You could look server configuration at this https://github.com/orientechnologies/orientdb/wiki/Configuration My Best, Hung Tran On Thursday, January 15, 2015 at 9:05:45 PM UTC+7, ATL wrote: > > Is it possible use IN query for large Record IDs command separated list. > Let's say if I have 5 million documents/records in OrientDB, out of 5 > million, I want to filter result with-in specific 1 Million Records ID's. > Using IN query is it possible to filter 1 Million records with , (comma) > separated Records ID to limit the result with in 1 Million out of total 5 > million records. > > I read in Help Document > > > - one or more *Record IDs*, by using the RecordID > > <http://www.orientechnologies.com/docs/last/orientdb.wiki/Concepts.html#recordId> > directly. > For example: select from #10:3 or select from [#10:1, #10:3, #10:5] > > How many max RecordID > <http://www.orientechnologies.com/docs/last/orientdb.wiki/Concepts.html#recordId> > we > can add in the comma separated list... This might solve our issue but is it > possible to pass 1 Million ID in query...or even we can pass 100k records > ID list in 10 loops to get the result and than combine that result. > > This document ID are not in sequence so range query will not work. > > Let me know if above solutions works or if any better alternative. > > Thanks > -Vishal > > *Notice of Confidentiality* > > *This email message and its attachments (if any) are intended solely for > the use of the addressees hereof. In addition, this message and any > attachments may contain information that is confidential, privileged and > exempt from disclosure under applicable law. If you are not the intended > recipient of this message, you are prohibited from reading, disclosing, > reproducing, distributing, disseminating or otherwise using this > transmission. Delivery of this message to any person other than the > intended recipient is not intended to waive any right or privilege. If you > have received this message in error, please promptly notify the sender by > reply email and immediately delete this message from your system.* > -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
