You are not logged in.

TableTransform with count SLOW

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

avilner

Trainee

  • "avilner" started this thread

Posts: 1

Date of registration: Apr 27th 2012

  • Send private message

1

Friday, April 27th 2012, 11:45pm

TableTransform with count SLOW

I have an Extract coming from SQL Server database as a relational result set.
It returns 9200 rows. There are 5 columns which are "dimensions" (not building the cube yet, only doing aggregation), and the last column in the result set is a UUID value.

I am trying to create a TableTransform, with Only Aggregation/Projection, where I am doing a count on the UUID column.
It takes 3 seconds when aggregation is defined as NONE, and it goes up to 90-100 seconds for when aggregation is COUNT.

Is this kind of performance expected? Is UUID type of value throwing it off (column is defined as uniqueidentifier SQL Server type)?

Thank you in advance!

--Alex

Similar threads

Used tags

Only Aggregation/Projection, TableTransform

Rate this thread