ARS 7.5 on Solaris/Oracle: On a form with about 330,000 records, searching on a small character field (for instance, Last Name) "smith" with no other qualification might take 2-3 seconds. Say that field is indexed for FTS. If I search as a user with FT rights, the same search takes 20-25 seconds.
Is that a normal performance difference? I have already rebuilt the indexes by removing, then adding the fields back via Dev Studio. I thought FTS could offer performance advantages or at least not be so much slower. This is the largest number of records I've kept live at one time, so perhaps it's just what I should expect? The reason we've kept it is for case-insensitivity. Additionally, if I run even a semi-substantial report (say just on a month of data), the search will timeout if I'm using a FT account. David --- David Durling Enterprise IT Services University of Georgia _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
