What is considered small amounts of data? Is it based on the size of the QV application, or what the database structure looks like (the number of joining tables)?
I normally always try to create a single table in my applications, as I feel I understand the structure, and it is easier to create QVD files based on this, with the same structure, or to export the whole database to Excel.
Most of my applications are less than 100 MB in qvw format. Probably a small application compared to some (a few million records with 50 to 100 fields/dimensions). In some applications I have close to 1 GB. I might have a go at creating a star scheme instead, to see if they perform better.
