Size of the database which can be handled ?

answered 2011-12-05 00:13:08 +0800

simonmassey
90 ● 1

Excel could not handle 1 million rows. I don't think you will find any web display tool which would. If you cannot build the solution in Excel then you are not going to solve the problem in a browser.

Think of Excel Pivot Tables or ZK pivot tables as graphic tools to explore data; not number crunching engines. A database server is a number crunching engine; displaying some of its output in a pivot for the user to explore is likely to be the way forwards.

answered 2011-12-26 20:36:43 +0800

zippy
504 ● 1 ● 2

Older version of MS Excel were restricted to 65536 rows per worksheet.

Excell 2007 brings some good news to this restriction - the number of rows is larger by about 16 times - summing up to 1,048,576 rows.