>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