I'm a java developer and have no idea about the database administration. If you can thow some light on this issue it'll be of great help.
I have a table with around 10 million records of data in it. I have an object mapping to this table and I also have some GUI screens which show up some details from the underlying table.
My application becomes extremely slow when I run it with so much data in the database. so much so that it takes nearly half an hour to bring up the windows with some list boxes populated .
Can you advise me to look at some issues like table space sizes and other issues which affect performance. How "Select" is afftected with the verticle increase of table?