#arangodb

[simple-logic]

#Guess

Let's play 'Guess The Logo!' 🤔

Can you name it?

Drop your guesses below!👇

💻 Explore insights on the latest in #technology on our Blog Page 👉 https://simplelogic-it.com/simple-logic-it-services-tech-insights-blog/

🚀 Ready for your next career move? Check out our #careers page for exciting opportunities 👉 https://simplelogic-it.com/careers/

[skitsanoscom]

count(doc) is faster than count(doc._key)

One more hint on queries performance tuning. Although document keys (_key) are indexed, counting docs is faster by the entire doc, not by a key of the doc.

So the following query will be faster

let ds = (for doc in random_data return doc) return count(ds)

Compare to this one, that in my case went for entire 12ms slower on 100K records

let ds = (for doc in random_data return doc) return count(ds._key)

[skitsanoscom]

AQL performance and indexes

A little experiment with 100,000 randomly generated docs queried in two ways produce the same result, but time takes on execution is like 80 times different.

The following query took like 1.6s to execute

for doc in random_data limit 1,100 return merge(doc, { client: ( for client in random_data_details filter client.source==doc.value return unset(client, "_id","_rev") ) })

While this one, took just 0.02s

for doc in random_data limit 1,100 sort doc._key DESC collect project = doc, found_client = ( for client in random_data_details filter client.source==doc.value return unset(client, "_id","_rev") )[0] || {} return merge(project, { client: found_client })

Worth mentioning here that those benchmarks are valid only for the case when you have indexes enabled on datasets you querying.

Without indexes enabled the first query took 17s and second one executed with 8.5s.

Indexes allow fast access to documents, provided the indexed attribute(s) are used in a query. While ArangoDB automatically indexes some system attributes, users are free to create extra indexes on non-system attributes of documents.

[iamprogrammerz]

Learn ArangoDB for Absolute Beginners ☞ https://morioh.com/p/ca7833bf949f #ArangoDB #Databases #Morioh

[iamcodegeek]

Learn ArangoDB for Absolute Beginners ☞ https://morioh.com/p/ca7833bf949f #ArangoDB #Databases #Morioh

[iamaprogrammerz]

Learn ArangoDB for Absolute Beginners ☞ https://morioh.com/p/ca7833bf949f #ArangoDB #Databases #Morioh

[iamprogrammerz]

ArangoDB Full Course for Beginners | Learn ArangoDB | ArangoDB Tutorial ☞ https://morioh.com/p/0d63e21e8ebf #ArangoDB #Morioh

[iamacoder]

Learn ArangoDB for Absolute Beginners ☞ https://morioh.com/p/ca7833bf949f #ArangoDB #Databases #Morioh