One large „query” is better than a lot of „get” methods
With most work, people are always looking to make things quicker, more efficient and productive.
I might not be able to help in many Business areas but I can show you how to improve the way you query!
Tested on the table: Logs [syslog]
Number of rows in table: 58 927 139
Number of sys_ids in probe: 10 000
*** Script: START
*** Script: probe size: 10000
*** Script: one_query_time: 3164
*** Script: get_query_time: 6342
*** Script: END
If you’re interested in receiving the script, please reachout to us and reference this post.