>I removed the deleted()s. Performance is a lot better. Thanks. Any other ideas of increasing performance?
There may be others here who know other things to tweek. Those are the things that came to my mind immediately when you indicated that there was a Network performance problem.
I still struggle with the best way to set up a table and its indexes in order to get the least data to travle across the wire, while getting the user all the data that they require.
One other thing that came to mind is to Use composite key expressions instead of multiple tags on required fields. Basically if a person can query on ZIP and State, then create an index on ZIPState. The combining of the two in that order will reduce the data that is brought back because it will reduce the set of records greatly by just the zip.
The above really points out that you need to know your data and is distribution. Also by what methods and fields your user will be trying to get to the data.
HTH
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope