S Ganesh wrote:If I keep calling getExportedKeys() method recursively , it takes around 3 minutes for 50 tables or so (which is really slow)
Roel De Nijs wrote:But you also invoke the getExportedKeys method again with the exact same parameters. Why?
S Ganesh wrote:The total tables in the database would be around 100-120 tables. getExportedKeys for each tables varies. But on an average I would say around 2-3 seconds.
S Ganesh wrote:If I comment out the recursive call , it would be quick only as it is just gonna verify child tables for only a single table only. May be 1-2 second(s) or at max 3 seconds (varies for each table)
S Ganesh wrote:The total tables in the database would be around 100-120 tables. getExportedKeys for each tables varies. But on an average I would say around 2-3 seconds.
S Ganesh wrote:But wouldn't it be a bad approach to call getExportedkeys for each table , considering it would be around 1000 tables or so.
S Ganesh wrote:I guess that might be the alternate solution. I will opt for queries then. I have a doubt in queries. In oracle there is a query syntax where I can start with the specified table name and link with the child tables and all its descendants.