By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,871 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,871 IT Pros & Developers. It's quick & easy.

OLAPy stuff crawling a bit

P: n/a
I'm emulating ROLAP in Postgres, populating a sorta-cube from a table with
200 million rows in it. Many aggregates over around 20 fields. Two questions
:

1. Currently, it takes 1000 seconds to build a cube from scratch. What,
other then trivial, tricks can be done to speed up the monstrous SELECT

2. Adding a text field to the source table makes a select really crawl even
when such field isn't in the select. Is this supposed to be so ?
Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.