General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I've been using FoxPro for a number of years but am just now starting to work with local and remote views.
I have a 1+ gig file that contains over a million records. I created a view of the table but when I USE dbc!newLocalView it now takes several minutes to load the view with data. During this time the user has to just wait until the query finishes running. Is there a way that that query can run in the background and release control back to the user immediately after the USE statement. There are many activities the user can do that are not related to the view that would be loading in the background, thus they could be more productive if they did not have to wait for the query to load before they can start using the application.
I know that I can create paramerized views and limit the amount of requested data, thus it loads quickly but I want the user to have access to the entire database, once it is loaded.
I've looked at several properties related to views but the ones that seem to relate to restricting the amount of data being 'fetched' only apply to remote views.
In short, I'd like to use a local view but have it load instantly much like a normal DBF table. The reason I'm trying to convert from using a DBF table to view is to avoid data/table corruption issues. I've heard that if you are using views, you will rarely have a corrupted table. Is this correct?
TIA,
Robert
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