Hi all, i want to know how long does it take to complete the query?
Vào lúc 02:17:23 UTC+7 ngày Thứ Bảy, 26 tháng 5, 2018, Nigel Budden đã viết:
>
>
> On Friday, May 25, 2018 at 2:11:06 AM UTC-7, Simran Brucherseifer wrote:
>
>> Hi Nigel,
>>
>> did you define any indexes? For movies.csv, it would probably make sense
>> to use this as _key. The primary index is over this attribute, thus sparing
>> you an additional index.
>>
>> Another way would be to assume that tags are written in the same case or
>> update them to be all lowercase for instance, then get rid of the function
>> calls to LOWER() and create an index on movieId,tag in collection TagLinks.
>> The index can then be utilized for the following filter condition:
>>
>> filter m.movieId == tl.movieId And t.tag == tl.tag
>>
>> Be sure to have a look at the execution plan to see what will be done:
>>
>> Execution plan:
>> Id NodeType Est. Comment
>> 1 SingletonNode 1 * ROOT
>> 3 EnumerateCollectionNode 10000 - FOR m IN Movies /*
>> full collection scan */
>> 4 EnumerateCollectionNode 100000000 - FOR t IN Tags /*
>> full collection scan */
>> 7 CalculationNode 100000000 - LET #6 = { "_from" :
>> m.`_id`, "_to" : t.`_id` } /* simple expression */ /* collections used:
>> m : Movies, t : Tags */
>> 9 IndexNode 100000000 - FOR tl IN TagLinks /*
>> hash index scan, scan only */
>> 8 InsertNode 0 - INSERT #6 IN MyTags
>>
>>
>> Indexes used:
>> By Type Collection Unique Sparse Selectivity Fields
>> Ranges
>> 9 hash TagLinks false false 91.46 % [ `movieId`,
>> `tag` ] ((m.`movieId` == tl.`movieId`) && (t.`tag` == tl.`tag`))
>>
>> Hi Simran,
>>
> I did a bit of tweaking of my indexes as you suggested, along with fixing
> the casing and that did the job, thanks for the suggestion.
>
>>
>>
>
--
You received this message because you are subscribed to the Google Groups
"ArangoDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/arangodb/2e9617b1-8c92-4b36-ba2d-ab72140d418cn%40googlegroups.com.
