I've got a view that concatenates and formats lastname and firstname. It has around 15,000 names in it and it seems to take too long to load. There are no joins to the SQL statement. Any known tricks out there that might help speed the loading of this form. It is conceivable that in the future, this table will have over a million records in it and it is going to have to load quickly.
The preference is to use views for everything to be able to switch between local and remote data. The views that are filtered and properly indexed for Rushmore run quick enough but the views that need an entire table load slowly.
Thanks,
Steve Despres
EZ Data Inc
sdespres@erols.com