I am working with a legacy R5.3 GA based environment and I have a requirement to retrieve all the components which are published to a specific target and also filtered based on a schema.
I have written a custom code using TOM API (optimized it as per best of my knowledge) to do this task, however, the real problem is that there are millions of components and out which more then 50 K components are the result of the filtered query. Since It is older configuration hardware the result is taking more than 6 hours. (And this too sometime gives different result). Is there any other possible faster and consistent way to retrieve this. Specifically, I am looking for a SQL query on Tridion Database which can give this result.