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.
