Page 1 of 1
Cross Table Taking much Time
Posted: Tue Aug 07, 2007 4:16 am
by dssiddu
Hi all
Cross Table analysis Taking much Time to complete ?
Could you please tell me can we do it faster ?
Adv thanks
Posted: Tue Aug 07, 2007 5:52 am
by ray.wurlod
Cross table analysis has to compare each column in one table with every column in the other table, and every pair of columns in one table with every pair in the other, and maybe more depending on how you've specified the task. So it's a lot of work. The only way you could reduce the time is to remove some of the columns from the analysis, and/or to use smaller data sample sizes.
Posted: Tue Aug 07, 2007 6:16 am
by dssiddu
Thanks a lot Ray
But my question is if one database contains more than 100 tables then each table has to compare with 99 tables am i currect so many column pairs . Could you please tell me approximate time to run this for 2000 rows sample data ??
Posted: Tue Aug 07, 2007 2:33 pm
by ray.wurlod
Somewhere between zero and infinity. How long it will take really depends on the results of column analysis, especially the frequency distributions. In practice expect hours rather than seconds with this many tables.
Posted: Wed Aug 08, 2007 3:07 am
by dssiddu
hi ray
thank you so much for your info........