CapnSpek commented on issue #1004: URL: https://github.com/apache/age/issues/1004#issuecomment-1701191551
Same results as Wendel. **My setup** `test_array` having `vertex_id` and `labels_id` array. `test_int` having `vertex_id` and `label_id` int type. The 2 tables were populated by generating an sql file through a C program and running the sql file. [Here](https://pastebin.com/9fUWSejP) is the code for both programs. **Tests** 1. Listing vertices by a single label_id 2. Listing vertices by using OR on multiple label ids. 3. Listing vertices by using NOT label_id. Average vertices by a single label_id result: One label query execution time - 82.2 ms `OR` label query execution time - 103.8 ms `NOT` label query execution time - 123.8 ms Average vertices by multiple label_ids result: One label query execution time - 186.19 `OR` label query execution time - 254.25 ms `NOT` label query execution time - 200.78 ms It appears we are looking at a 2x+ increase of execution time unless we can optimize it further. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@age.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
