Software

Ask something
Discussion Locked

Temp tables or arrays?

0 helpful
1 reply

by mrspost

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

1 reply

by raghx_2000

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.

This discussion is closed to new replies.