File Tracking System
I would like to use MOSS 2007 to track folders (file tracking system). I have created a site and a list with approximately 106000 entries. I have setup views etc and it all works - however the performance is not that good. I was wanting to be able to use this list to add new folders, check folders out etc.
I could have the data in a SQL table and use the BDC to view it but how would I use The BDC to update/add data in SQL?
What would be the best way to do this?