Skip to Content
0
Jan 15, 2008 at 03:43 PM

Practical limitations to user defined table

29 Views

Hi all,

I am thinking of setting up a user defined table which will have 5 columns and around 45,000 rows. It will be used in a simple formatted search to retrieve the value in column 5 when the values in columns 3 and 4 match an item code and an invoice header code on an invoice.

Will a table of this size slow things down significantly?

Regards, David.