Reply to thread

Message

<blockquote data-quote="MJGraf" data-source="post: 1027549" data-attributes="member: 17886">Thanks a lot Lehmden, that's very interesting!First of all, a DB size of 10GB must IMO not be a problem for MP2. In MS Outlook 2003 and 2007 e.g. the standard size limit for pst files was 20GB since 2010 it's 50GB. And Outlook is perfectly fast with a 20GB pst file - tested this myself. This has to be the goal for MP2.As to your observations: Do you still have the 2Gb or better the 3Gb version of your DB?. If so, could you please First: restart your MP2 Server with your working DB, do exactly what you described above and then post your SQLDebug.log here.Second: restart your MP2 Server with your 2GB or 3GB version of the database and do exactly the same as before. Then post the SQLDebug.log generated in this test.This would be very helpful in improving the speed, as in this log we can see exactly every single SQL command as well as the exact time it took the database to execute this query.Thanks for all your help!Michael</blockquote>

[QUOTE="MJGraf, post: 1027549, member: 17886"] Thanks a lot Lehmden, that's very interesting! First of all, a DB size of 10GB must IMO not be a problem for MP2. In MS Outlook 2003 and 2007 e.g. the standard size limit for pst files was 20GB since 2010 it's 50GB. And Outlook is perfectly fast with a 20GB pst file - tested this myself. This has to be the goal for MP2. As to your observations: Do you still have the 2Gb or better the 3Gb version of your DB?. If so, could you please First: restart your MP2 Server with your working DB, do exactly what you described above and then post your SQLDebug.log here. Second: restart your MP2 Server with your 2GB or 3GB version of the database and do exactly the same as before. Then post the SQLDebug.log generated in this test. This would be very helpful in improving the speed, as in this log we can see exactly every single SQL command as well as the exact time it took the database to execute this query. Thanks for all your help! Michael [/QUOTE]

Verification