Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Item Master and Location Limits?

prog_0927

prog_0927

Programmer
Jan 3, 2022
56
US
Progression 7.9.310


We are looking to add a significant number of part numbers per year to the Item Master and Item Location Tables. We are going to go from 1200 parts to 6K parts a year. Have you seen any issues with these tables have 100-200K parts in there (adjusting for moving off Progression in 5-7 years)? Does anyone have that many in these tables? Any process affected?
 
Sort by date Sort by votes
There is no limit except your SQL Server Database size.

That said, why on earth are you adding 200k items?
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

M
  • Locked
  • Question
Macola designer and flex code
Replies
1
Views
1K
dgillz
dgillz
prog_0927
  • Locked
  • Question
Default Item Location Missing on File
Replies
2
Views
394
prog_0927
prog_0927
JD5241
  • Locked
  • Question
Identifying Items With Different Prices by Location 1
Replies
2
Views
321
JD5241
JD5241
nsiegmundt
  • Locked
  • Question
How to edit the "search_desc" field for an item inside of macola (table imitmidx_sql)
Replies
1
Views
398
dgillz
dgillz
J G PM
  • Locked
  • Question
Macola Line Item Comments
Replies
2
Views
313
J G PM
J G PM

Part and Inventory Search

Sponsor

Back
Top