> As you can imagine the view is slow either way. I am trying to see
> if having 31 different TIB_Querys is better than having a single
> huge query record.

I would always (ouch, I don't like that word) go with the 31 specialized queries vs. one large one. And I would probably use TIB_Cursor if speed is essential and move the data into a local storage container (I don't know what your UI implementation is). You could thread the data access which should improve any apparent sluggishness on the UI.

Ed Dressel