FWMARIADB: XBrowse million record table in one second

Board index FiveWin para Harbour/xHarbour FWMARIADB: XBrowse million record table in one second

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

FWMARIADB: XBrowse million record table in one second
Posted: Sat Mar 25, 2017 11:38 AM

Regards

G. N. Rao.

Hyderabad, India

Posts: 153

Joined: Tue Aug 05, 2014 09:48 AM

Re: FWMARIADB: XBrowse million record table in one second
Posted: Sat Mar 25, 2017 11:40 AM

Downloaded sample program
It is Amazing Fast, unbelievable with such numbers of records
Congratulation

Best Regards

Regards, Greetings

Try FWH. You will enjoy it's simplicity and power.!

Posts: 817

Joined: Sun Jun 15, 2008 07:47 PM

Re: FWMARIADB: XBrowse million record table in one second
Posted: Sun Mar 26, 2017 11:49 AM

Fantastico

Una duda...
Se trae el millón de registros del servidor al cliente?

o realmente sólo se trae mil? que son los que va a tratar en ese momento?

Lo digo por el segundo parámetro

oRs  := oCn:RecSet( "custbig", 1000 )

Seguramente usaras:

SELECT * FROM custbig LIMIT nRecAct, 1000;

En todo caso es una buena idea.

Te felicito

______________________________________________________________________________

Sevilla - Andalucía

FiveTech Support Forums