To identify bottlenecks please do the following:
1)Not sure if you are using the right query with the right joins defined in the query.Please check Workgroups Database .to understand the primary and foreign keys.
2)analyse the data with workbook performance Analyze Data with the Sample Performance Workbook this will tell where it is taking time.
3) order of
4) data synchronization can be done with postgressql and other database
5) sample workbooks are there that can be used directly
6) performance recording
hope it helps.