Retrieving all sys_id's from large datasets quickly (cmdb_ci)
I am trying to query the cmdb_ci table to retrieve all of the sys_ids. This table currently has around 200K entries. I have tried GlideAggregate/GlideRecord and it takes on average 16-17s which is way too slow compared to a directly SQL query (400ms)...
