>We have completed our final phase tonight. The site now runs under SQL Server and in several locations, the increase in response time should be significant. This means, we no longer have the issue of the VFPOleDb provider. So, the memory issue which was affecting the response time several times per day should be history. The same goes with PHDBase. For years, we have run with it. This is now under the full text indexing of SQL Server and the response time, in most situations, should also be significant.
>
>Basically, the site processes in average at 5 times faster than before. The average response time is 0.2 second.
>
>As for the search, there is now one type of search and that is an exact match. So, basically, whatever you enter, the search will try to find messages containing the text as is either in the message title or in the message itself, depending on the search location. The search will also be enhanced within the next few days. So, you might want to wait a little bit before making comments on it as we have more to come.
>
>Thanks to Naomi for having done an intensive amount of tests tonight. This has helped me a lot. I still have to fine tune a few things here and there. But, the core functionality of the site should be pretty stable.
Yes sir. It's running very quickly now. Congrats on all the work Michel.