Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Urgent please help me!!
Message
 
 
To
16/04/1999 12:44:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00209059
Message ID:
00209093
Views:
21
>i nhave a very big tables who the remote user have to consult
>any field of the tables conduce to a folder of graphics(who aren't in general fields.. are in a fiels of a folder)
>
>the problem is tha a consult take a lot of time to be showed!!!
>
>how can i decreasy the time of show consults ????
>
>im trying so hard to ge it
>
>tahnks in advance
>regards

By remote, do you mean dial-up with a modem? Or the table is in a database like SQL Server or Oracle? You can create a parameterized view of the table so only a limited number of records are returned at a time. A parameterized view would have a WHERE clause with a filter something like where SomeKeyField = ?lnKeyID. If you are retrieving graphics, you may have to live with a long time to retrieve depending on the graphics size.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform