I've been suffering from some performance issues with Graffiti since I've begun using it. Every once in a while when editing a post, or going to a page it hangs for about 30 seconds. It eventually does load the page. I'm using VistaDB right now - if I moved it to SQL Server would the performance be improved? Right now there is no load on the site as we're still in development.

flyguy,

Keep in mind that VistaDB is an in-memory database, so if IIS gets restarted or your appPool recycles, then a good bit of it needs to get put back into ram.  We do believe that SQL Server would be your best performing option, but there are plenty of people that use VistaDB as their main database (for instance, the VistaDB blog site).

Also remember that switching between the supported databases with Graffiti is pretty simple with the DataMover utility.

Hope that helps,
David L. Penton
Telligent

Thanks for your reply. This hang up occurs multiple times an hour so I doubt it's IIS resetting. I will move the database to SQL and I'll let you know if this fixes the problem.

 then seems have better use sql db