My application hits database to load different sections in UI homepage. All sections are dependent on one input. So I created a proc that returns all data in different cursors. Now count of cursor return is around 25.
My question is: What is drawback of returning multiple cursors, though each do not have data more than a hundred rows (some also has one or two rows), from oracle pl/sql procedure? Cost of fetching for each cursor is very low, so they are quite fast.
Will it be better if I split proc into two and make 2 separate db hits to fetch data?