Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hello all,
I am looking for some suggestions. I am designing a VFP6 application front end for an Oracle8 database. I am currently accessing the database through Remote Views stored in a DBC that is created on the fly when the User Logs in. The problem that I am having is that it is just too slow.
I have experimented with using SQL Passthrough however by doing so I must write all of the INSERT,UPDATE, and DELETE statements in SQL rather than the native fox. Plus I cannot use parameterized views to return just the records that I need. I have to code each of these in SQL Passthrough.
The third thing that I have noticed is that the Oracle connection is only open when the views are in use. With SQL Passthrough the connection remains open until a sqldisconnect is executed.
What are you guys and gals using to connect your Oracle databases? Any help would be greatly appreciated.
Matt
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement