> 4 seconds to pull up all the Smith records (about 15 > records) > > A very acceptable result. Sooo, I've decided to > refresh the data in that 8-field Name table every > day when the first user logs on via a command in > Rbase.dat.
You have two other solutions. The first is to experiment with index only retrieval. Create an multi-column index that includes all columns from the big (217 column) table that are used in the view. In general, if R:Base can get its data from an index rather than reading the table, it will do that. In effect, you will be automatically maintaining your smaller subset table in the index file without any code or effort on your part. Alternatively, you could split your big table into an 8 column main table and a second table with the other 209 columns. Use the 8 column main table whenever possible. You may have to fiddle with your forms a bit. Give the tables different names from the current table, then create a view that joins the tables together and give the view the same name as the original table -- now all your reports will still work. -- Larry __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/
