Hello all,
I have a bit of a critical issue. Roughly 2 weeks ago, we've hit the 100,000 order mark(woohoo!) and today seems like the first day where we're experiencing several strange issues. As of today we're noticing several odd behaviors with visual. It started with some actions taking much longer than normal(i.e, billing, order entry, etc). The problem then presented itself as longer than normal queries directly in the database(i.e, queries normally taking 1-2 seconds are now taking 30+ seconds).
The latter problem seems to come and go throughout the day, however the latest issue we're noticing is some orders are simply not in the database. Some sales agents orders are showing up and some aren't. There's no pattern just yet so we're thinking either a user setting or a setting with the customer maintenance.
Any thoughts are appreciated.
