>Nadya,
>
>Just a quick test and I think that the more the number of records returned the quicker the next screen is displayed.
>
>What can I use instead of a grid, that gives the effect of a grid?
>
>Ria

You may either use views or select sql and then use grids or use SET FILTER with Browse command if you want just show data. You can almost simulate grid using Browse with this function:

********************************************************************
*  Description.......: SetBrowseProps - sets properties for Browse
*  Calling Samples...: 
*  Parameter List....: 
*  Created by........: Cetin Basoz 
*  Modified by.......: Nadya Nosonovsky 10/10/2000 01:44:19 PM
********************************************************************
lnRecno = recno()
with myBrowse
  .Setall("DynamicBackColor","iif(recno()="+str(lnRecno)+","+;
  	str(.Columns(1).Text1.SelectedBackColor)+","+str(.Backcolor)+")","column")
  .Setall("DynamicForeColor","iif(recno()="+str(lnRecno)+","+;
  	str(.Columns(1).Text1.SelectedForeColor)+","+str(.Forecolor)+")","column")
  .deletemark = .f.
*  .GridLines = 0
  .scrollbars = 2
*  .AllowRowSizing = .f.
*  .AllowHeaderSizing = .f.
*  .Setall("DynamicBackColor","iif(recno()%2=0,255^3,255^2)","column")
*...
endwith

Check Name clause in Browse command in help.

This is from Hacker's Guide:

BROWSE has no place in applications. In FoxPro 2.x, you could make some argument for it because there were no good alternatives. You either used BROWSE or lived without its row-at-a-time view of data. In Visual FoxPro, you can use a grid for that view and ignore BROWSE except as a powerful, interactive tool for you, the developer. As for CHANGE/EDIT, it's been obsolete for a long time.

BROWSE does have one new clause in Visual FoxPro worth learning. A BROWSE is really just a grid, although you can't find a BROWSE's Parent. The NAME clause lets you manipulate the grid with its PEMs, instead of relying on the same old confusing, complex clauses. The table below maps BROWSE's clauses to the grid and column properties, events and methods that give you the same (or often better) functionality.