« previous next »
Pages: [1]

Author Topic: Performance in Transformer  (Read 467 times)

Offline asdf

  • Community Leader
  • *****
  • Posts: 96
  • Forum Citizenship: +0/-0
Performance in Transformer
« on: 24 Aug 2011 05:20:51 pm »
If i have data in excel and same amount of data in the database, then which would give better performance in transformer.
Logged

Offline twlarsen

  • Community Leader
  • *****
  • Posts: 123
  • Forum Citizenship: +5/-0
Re: Performance in Transformer
« Reply #1 on: 25 Aug 2011 12:25:09 pm »
How much data are you talking about?  If it's small enough to fit in excel, theres probably not a noticeable performance difference.
Logged

Offline cognostechie

  • Statesman
  • ******
  • Posts: 753
  • Forum Citizenship: +55/-0
Re: Performance in Transformer
« Reply #2 on: 27 Aug 2011 07:01:12 pm »
EXCEL without a doubt !

However, when you talk about this, this performance is about time taken to build the cube, not the the time taken to query the data from the cube !!
Logged

Offline asdf

  • Community Leader
  • *****
  • Posts: 96
  • Forum Citizenship: +0/-0
Re: Performance in Transformer
« Reply #3 on: 29 Aug 2011 06:11:17 pm »
Why excel? I would have thought Database, since we could have used indexes while data retrieval
Logged

Offline cognostechie

  • Statesman
  • ******
  • Posts: 753
  • Forum Citizenship: +55/-0
Re: Performance in Transformer
« Reply #4 on: 20 Sep 2011 07:05:39 pm »
because Excel is a flat file so the data is read faster. Even if you have indexes in the DB, the DB still has other processes running when you try to retrieve the data and the DB is always in multi-user mode whereas Excel file is always in a single user mode.
Logged
Pages: [1]
« previous next »