hello
I do not know if the problem is from my particular instance or even if the issue is related.
… but I was starting to experience slowliness and my users were complaining…
Saturday night i upgraded from 7.7.6 to 7.7.8
the performance appeared to be the same.
I restarted the server with no noticeable improvement
I looked at old notes that I took in the 6.5 version time (fortunately)
I found out a note that I took indicating that I then improved performance by cleaning up the email_addresses table
you see my table contained apostrophes and < signs… not good!
I ran the script that I noted back then which basically look like this
SELECT TOP 100 * FROM email_addresses ea WHERE ea.email_address LIKE '%''%'
and I saw 128 bad records…
I ran an sql script to clean this up and the speed improved noticeably…
So could you run the script to check if you are experiencing the same issue? … and report if you do…
I really do not know if this was from SuiteR or if an import turned bad or one of our integration caused this.
obviously if you do have the same scenario it is SuiteR related…
BTW i am running MSSQL 2012…
Serge