FWMARIADB 17.03 Fast Loading/Browsing Very Large Tables

[aferra]

0.998 seconds here!

Great work, Rao!

PostGree +1

[Carles]

Nageswaragunupudi,

Fantastic !

Simple code, very fast and easy, congratulations.

A couple of questions.

1.- "oCn:RecSet( "custbig", 1000 )" is the pagination size ?
2.- Do you need a id or key unique, no ? then you need define this special field. This is true ? Or how it works?

Great !

edited: (field married don't update)

[nageswaragunupudi]

1.- "oCn:RecSet( "custbig", 1000 )" is the pagination size ?
2.- Do you need a id or key unique, no ? then you need define this special field. This is true ? Or how it works?

1000 is the pagination size.
We use this syntax SELCT.... FROM table ORDER BY <uniquekey> LIMIT ? OFFSET ? internally. LIMIT ? OFFSET ? is more reliable than LIMIT ?,?

The recommended usage is going to be oCn:RecSet( <table/sql>, -1 ).

RecSet (also Rowset) method automatically ascertains the primary or unique field to construct the ORDERY BY expression.

Existing oCn:RowSet() also operates on a similar principe. But in this case, RowSet keeps expanding automatically on demand, whereas in case of RecSet() navigation is by paging. It is the way the paging is managed that gives experience of continuous navigation of the entire table.

Note:
RowSet() is already a fully developed class
RecSet() is under develoment. In 17.03 it can be used with limitations and by 17.04 it will mature fully.

[augustogomes]

Is there any chance for 'FWPOSTGRESDB' ?

As of now, we do not have any plans.
We would consider if we see many users interested in it.

I have interest in the class for FWPOSTGRESDB, currently use third-party class.

[jose_murugosa]

Very Good,

I load and browse the 1.000.000 records database in 0.94 seconds in a slow internet connection.
Congratulations!!!!

An excelent work!!