General discussion


Temp tables or arrays?

By MrsPost ·
Which one is better for data comparison - temp tables or arrays?

I have just scads of records to compare and want to do it quickly.

I'm going to try testing the array route but wanted to know if anyone had some insite.

Thanks in advance.Marie

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by raghx_2000 In reply to Temp tables or arrays?

The Temp tables work faster coz it doesnt take much memory as the arrays do at runtime. It also depends on the circumstance where you must use arrays. If you would clearly say what sort of comparision you intend to make then its easy to choose between two.

Related Discussions

Related Forums