( I have a huge and growing geodatabase 10,000 fields now) and it's connected to a basic entry and search form for my coworkers to enter data with. Both have gotten extremely slow lately and I'm not sure what to do. I've compacted the database and deleted excess data. Right now it takes a good three or four minutes to simply OPEN. Submitting information also takes a very long time. Any ideas as to how to make it faster??
-two point feature classes and five tables (one point class is the extremely large one)
10,000 fields? Have you considered separating out these fields into different tables and relating them to each other? this will be easier to manage. From this you can generate Views (as long as you are using the Enterprise Geodatabase in SQL).
I have thought about separating them into different tables...just not sure how to go about that yet.