We have about 150k threads with roughly 2.3M posts.
Our Database is 2.3GB
Attachments are stored separately (file system) for another 29GB
Import of my Threads and Posts took 51 hours. There were several time out errors that required an F5 to resume the import. No errors though. Now I am onto Attachments and watching a .01 tick every 5-6 seconds.
My prod and test forums are on the same web and db servers. Since this was my first pass I went vanilla on the install and import.
I was wondering if there was something I could do differently to increase performance? Is it possible to be live at the same time an import is running or would that cause issues? I just need to keep downtime to a minimum, the competition loves our downtime.