Sage 100

Have the need to create a UDF Table to validate a field. The table will be approximately of 2,000,000 records. Has anyone worked with such a large file?? Would it be possible?? Feedback please!!!!!

Editing or looking up values in the UDT is going to be a bear. I have a client with 100's of items in the UDT and scrolling to the end is a long haul. I can only imagine that validating the UDF is going to be slow also.

I think you'll need to specify if its lan, client server or sql. Either way, my gut is you'll need a developer like @AlnoorCassim to write something that runs a stored procedure on a sql server (regardless if this is sql or not) and returns back the validation or its going to be painfully slow

In answer to your question - try doing a lookup on a paperless office view with over 10k records. I believe that without outside intervention you'll probably have a similar experience. This is one area that I'd tell the user they are going to pilot test or assume all risk of speed issues.

I second everyone's concerns here. Let me ask what type of data are you putting into the UDT? Maybe there's another way to do this.