I have been left in charge of a VB.Net program that pulls data form a Pervasive 9.1 database. The program pulls data from a View in the Database, unfortuantly this view isnt the fastest in the world and it hangs the VB.Net program while it pulls the current data. My thoughts were to create an update table within Pervasive that gets updated everytime data in this view changes My program would then pull the data from the table rather than the view, I am hoping this will speed up the data pull from the program as no queries are being run, just a Select Statement to the table. My problem is, I have never used Pervasive and have no idea how to do this. I dont even know if it is possible to run an update on a table as soon as data has changed.
Any help would be appreciated.