>>You would use a different search mechanism (not PHDBase) with SQL Server. I'm not sure how would you achieve the same functionality for message searching.
>
>This is another issue. For now, the code is .NET migrated for that part but the data remains VFP, which does the job pretty good so far. So, the search engine will remain as is for a while. In SQL Server, I have done some tests two years ago and I obtained about the same results as performance issues go.
Did you use FULL TEXT search in SQL Server? Just curious.
I think I noticed a slight delay with the searches comparing to what it used to be few years ago. It also looks like the first search is slower, but if you make another search without leaving the Search screen, it comes a bit faster.
But of course, these are not scientific, just a user's observations.
If it's not broken, fix it until it is.
My Blog