Hi!
I've downloaded trial version of your driver in order to test possibility to switch to it. We use SSAS in our environment as OLAP-solution and Postgresql as DWH.
I have a few questions and I wonder you can answer on it.
1. If I add any table into DataSourceView while I'm designing database it always runs query against this table and retrieves all rows it contains. If we're talking about dimensions with several thousand rows then it's OK, but when I try to add fact table with several hundred million records, IDE hangs up totally. I tried to change "Default FetchAll" option to False, no luck though. Can this query be disabled any way?
2. I added empty fact table into DSV, created OLAP-cube with several dimensions, after that I filled this table with some data and tried to process cube. After 10 minutes OutOfMemory exception appeared. The same amount of data was processed using MS SQL datasource and PGOLEDB driver as well. Can I change driver's behaviour and not to consume all rows in one batch?
Thanks.
Work with SSAS
Re: Work with SSAS
1. Looks like DataSourceView doesn't use CommandBehavior.SchemaOnly explicitly when you add a table to it. If DataSourceView requires all records, this forces the provider to retrieve all records from the database. Does PGOLEDB driver behave in a different way?moonpie wrote:1. If I add any table into DataSourceView while I'm designing database it always runs query against this table and retrieves all rows it contains. If we're talking about dimensions with several thousand rows then it's OK, but when I try to add fact table with several hundred million records, IDE hangs up totally. I tried to change "Default FetchAll" option to False, no luck though. Can this query be disabled any way?
2.1. Try adding "Default Fetch All=false;" in your connection string. Does this help?moonpie wrote:2. I added empty fact table into DSV, created OLAP-cube with several dimensions, after that I filled this table with some data and tried to process cube. After 10 minutes OutOfMemory exception appeared. The same amount of data was processed using MS SQL datasource and PGOLEDB driver as well. Can I change driver's behaviour and not to consume all rows in one batch?
2.2. Try using the "UnpreparedExecute=true;" connection string option. Does this make any difference?
Re: Work with SSAS
Looks like PGOLEDB driver does not query table at all, just retrieves its structure.
Setting options as suggested above didn't resolve problem, still have the same problem
Setting options as suggested above didn't resolve problem, still have the same problem
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Work with SSAS
Thank you for the provided information sent by email. We are investigating it and will post here about the results as soon as possible.
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Work with SSAS
We have reproduced and fixed the bug with tables having lots of data in SSAS projects. We will post here when the corresponding build of dotConnect for PostgreSQL is available for download.
Re: Work with SSAS
Great news!
Looking forward to try updated version of your driver
Looking forward to try updated version of your driver
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Work with SSAS
New build of dotConnect for PostgreSQL 7.4.558 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=32922
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?t=32922