Well this is the latest version of ADOBASE, it has so many changes and optimizations that you will need to review the doc and comments on the same Class. Sorry but for now, Doc is only in Spanish, although the comments in the class are in English.
In search of a good performance I invented a Paging routine to emulate
the use of pages with ADOBASE, since these changes are deep ones, I'll
have to rethink the way in which the ADOBASE will be issued.
First there will be 4 differents versions, one for each of these DB
MYSQL, Ms Sql Server, PostGres and Oracle.
HAve a look at the difference in speed between these options of the example.
1.- Mantenciones
Server Side
Client Side
Paginado
2.- Browses
Simples
Paginado
Compare the access times shown in the ALERTS, the use of pages decreases time dramatically.
THIS ONE IS FOR MYSQL ONLY. Next ones within a few weeks.
This is the RELEASE CANDIDATE 1 version, after revieweing some annoyances, like the refreshing of xBrowse, which you'll be able to view in the sample ADOBASE.EXE, and other minor optimizations, I'll liberate the final version, within a week I think. ( Programmers time, it'll be a month
)Any comment, help, idea will be really apreciated.
Paging in ADOBASE was thought to speed up access from internet, I don't
suggests it to be used whithin a LAN, speeds are fast enough to use it whithout pages. Access to 1 million rows in 1 or 2 seconds.
There is a new Function called tAdoReg, which calls the actual row with all
the fields in it, you may have a recordset with only 2 of , for instance, 40
fields to gain access to a table, but if you need to edit 1 record, row, you now can call it like oRegCli:=tAdoReg(oDbCli ) , now oRegCli is a complete new recordset with only 1 row, which corresponds to the actual row of the main recordset, you can see menu.prg, Clientes Function to see it working.
The sample is basic and clear enough to understand the use and aim of the class.
ADOBASE is still a work in progress and can be optimized, if you find something it could help, please email me, and I'll put those changes in the class.
From Chile
Adolfo
Download from here
http:\\200.72.140.34\privado filea adobase.rar
I repeat, the test server is not a very powerfull one, but it works for the test.