>>Hello,
>>I am going to use VFP as the client for ORACLE server, but my concern is perfomance of ODBC. I would appreciate any comments.
>> Best regards,
>> Alex.
>
>vfp works much better w/ sql server. oracle speed is passable, but nothing to write home about.
32 bit ODBC is blindingly fast. You would be hard pressed to see a difference between remote SQL data and local data coming from a network drive. When I open remote views (with parameters to return a small subset of data) the data is in the browse window instantly. Even if the data source has 5 million rows. I am extremely pleased with the performance of VFP and ODBC. I am using SQL Server but I have used Oracle and performance is just as good.
Don't let anyone snow you with old stories about ODBC. For instance, yesterday I built a small form to display all the sql tables and views in the database in a combo box (filled by sqltables()) In a grid I display all the field information, filled by sqlcolumns. I have a button that builds a table based on the sqlcolumns structure but with the table_name field added (for a simple data dictionary). When I click on the button is scans through each table from sqltables and does a sqlcolumns call and then a scatter memvar, insert into my dbf. There are 60 some tables (1 call each to sqlcolumns) and 940 fields. The process to build the dbf (61 remote data access calls) takes less than 1 second.
Bob
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only