wxGridStringTable guide needed

[p***@gmail.com]

Hi all.

In wxGridStringTable documentation is said: "Simplest type of data table
for a grid for *small* tables of strings that are stored in memory."

But what is difference between small and big tables?

If I have say... one or two million string recordes in my databese table
can I upload them into wxGridStringTable?

What should have table-class is derived from wxGridTableBase to load big
tables from database?

I make housekeeping acconting program, if I use wxGridStringTable (after
adding some floats types, of course) is it enough class for tiny accountig
program?

Thanks in advance.

[Vadim Zeitlin]

Post by p***@gmail.com
In wxGridStringTable documentation is said: "Simplest type of data table
for a grid for small tables of strings that are stored in memory."
But what is difference between small and big tables?

In this context, "small" means something that you can keep without problem
in the memory.

Post by p***@gmail.com
If I have say... one or two million string recordes in my databese table
can I upload them into wxGridStringTable?

On modern hardware this would take a couple of dozens megabytes, so likely
not to be a problem from the above point of view. However reading millions
records at once on startup is still going to take some time and it would be
better to avoid doing it, especially completely unnecessary.

Post by p***@gmail.com
What should have table-class is derived from wxGridTableBase to load big
tables from database?

It should implemented the pure virtual functions defined in the base
class. A hint: some caching is strongly recommended, i.e. when implementing
GetValue(), don't get the value of just this cell, or even of just this
row, from the database, but get some window (say, 100) of rows around it.

Regards,
VZ