I'm trying to reduce the response time of my queries.
Don't know what this "fetch data in background" option in CF Administrator will do. Would someone please help.
I use MS Visual FoxPro as the database and was told that everytime I issue a SQL statement from my CF application, whether it be a select, update or insert, that it opens the table, and in effect opens a session. And that I need to issue a close table after each SQL statement to minimize the number of sessions which will cut down on the response time. The close table is specific to Foxpro. I tried the close table command and got an error :syntax error or access violation. I'm very sure it's not a syntax error.
DO I have to set the ODBC to be shared or something?
Longhorn
Don't know what this "fetch data in background" option in CF Administrator will do. Would someone please help.
I use MS Visual FoxPro as the database and was told that everytime I issue a SQL statement from my CF application, whether it be a select, update or insert, that it opens the table, and in effect opens a session. And that I need to issue a close table after each SQL statement to minimize the number of sessions which will cut down on the response time. The close table is specific to Foxpro. I tried the close table command and got an error :syntax error or access violation. I'm very sure it's not a syntax error.
DO I have to set the ODBC to be shared or something?
Longhorn