>I thought asking you might save a little time, which is my question as well. Is there a way to speed up the connection to Oracle from FoxPro? I know I could set up my data environments to NODATA ON LOAD, but that is not practical for most of the users, who will have only limited (filtered) access. The develeopment server is slow, but my P400 work station still takes 5 minites to load data on startup, and that is just TOO slow, esp when considering most of my users will be running P166 boxes. A good example on the slowness is I am currently impoerting the original data from a non-normalised FP2.6 db to oracle 8, fully normalised table via a VFP prg, and it has taken 15 minites to do the first 65 of 1475 records!
The company's Oracle guru had me change ODBC drivers last year. One of the concerns was performance. What are you retrieving from Oracle, a table or a view? Are you doing a view on Oracle tables in VFP? I decided early on that I was going to have to learn some PL/SQL programming so I could create views in Oracle and then drag the results into VFP. Trying to do a multi-table join in VFP was way too slow. If you can't create any views in Oracle, the next best thing might be to parameterize your remote views so that they only bring over one record at a time to work on.
The slow update time you're having with the updates is amazing. Oracle keeps a rollback table that, if it's turned on, can seriously effect performance when loading data. You can turn the rollback routine off using SQL*Plus, I believe. I would have to look up the commands to do that.
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