simple queries are slower than aql?

[weissglut-dev]

Hi,

I have an issue with the simple queries.

artist = db.collection(Artist.collection).document(key)

takes ~550 ms while

artist = list(db.execute_query("for a in prd_artist filter a._key == @val return a", bind_vars={'val': key}))[0]

only takes 110 ms

When I use the HTTP api of ArangoDB directly I see no difference.

Any chance to get this faster?

Thank you very much
Best Regards
Ludwig

[joowani]

Hi seyhbold,

I will take a look and give you an update.

Jay

[joowani]

Hi seyhbold,

I apologize for the (extremely) late replies.
The reason why the first query is slow is because some things are being eager loaded.

When you do:

artist = db.collection(Artist.collection).document(key)

You are actually hitting multiple API endpoints as collection(Artist.collection) is eager loading its type information (e.g. whether it's an edge or document collection).

The Database object caches the Collection objects. So as long as you are not recreating the Database object, the "slowness" will only be seen the first time you call db.collection.

You can also do:

collection = db.collection(Artist.collection)  # force the eager loading to happen
collection.document(key1)
collection.document(key2)
colleciton.document(key3)
...

Let me know if that works out better for you.

I am looking into ways to make everything lazy loaded (hopefully put in place next release) so multiple endpoints are not called outside of your control.

Thanks,
Jay

[weissglut-dev]

Hi Jay,

you're right. Storing the collection does the trick.
Code looks much cleaner now.

Many Thanks
Ludwig