I've gone ahead and moved the large data field into a separate, linked
record. I'd still appreciate any feedback on whether the behavior described
below is expected, and/or the correct way to accomplish the described goal
given the original record structure.
On Tuesday, December 9, 2014 10:49:24 PM UTC-5, BK wrote:
>
> I have a class, RawData, with records containing a *name *field and a *data
> *field (each data field holds 50+ MB of text). I'm trying to produce a
> fast query to retrieve just the RIDs and *name* fields for all RawData
> records. (The goal is to give users a summary view of the names and RIDs
> so that they can retrieve raw data by RID).
>
> Unfortunately, the queries I've tried are running very slowly and seem to
> be including/processing the large *data *field. Ideally, I'm looking for
> a fast Java API query that will return something along the lines of a
> JSONArray of the form:
> [ { "id": "#13:0", "name": "foo" }, { "id": "#13:1", "name": "bar" } ]
> which I could then use directly as a JSONArray in Java.
>
> In the console, these queries seem to produce what I'm looking for, but
> they're both too slow. With 16 records, the queries take about 25sec to run
> in the console on a development machine (the fetchplan doesn't seem to
> matter):
> select set(@this.toJSON('id,name')) from ( select @rid as id, ifnull(name,
> "") as name from RawData )
> select set(@this.toJSON('id,name')) from ( select @rid as id, ifnull(name,
> "") as name from RawData fetchPlan data:-2 )
>
> I'm using version 1.7.9.
>
> Is there a better/faster query for the results? Do I need to move the
> large data field into a separate, linked record?
>
--
---
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.
