Max No of Rows

Hi All,

I am developing a dashboard using QWASS and oracle DB.

The Base table is having more than 20 Lac records according to daily basis these records might increase.

Right now i developed with dummy records when i moved to production the data is large.

So that how can i work it out.

Can any body tell how many max no of row s will give good performance.

And also how many max records can hold by excel which is embedded with Xcelusius.

Thanks

Santhosh V