As far as I remember, I broached this question here before but probably a couple of years ago. We use Pervasive SQL2000i and the database for our ERP and financial systems. It seems to function fine with just the few odd glitches.
However, we also have a customer portal website where customers can enter orders, check stock, check financial accounts, etc. When I first set up this website over 2 years ago, I found that speed of access to the Pervasive tables was really slow and it could take over 5 minutes in some cases to load pages with complex queries. Obviously this is not acceptable so at the time I set up an MS Access database and run scripts nightly to pull data from Pervasive and store in the Access tables. The obvious drawback of this is that the data displayed on the website is not real time.
2 years on and we are going to try to look at acessing the data directly again. The setup is as follows:
We have a webserver which is quite old but which we hope to upgrade in the near future.
The Pervasive tables are on a seperate server which is newer.
I have a few pages on our Intranet which still accesses the Pervasive table as speed is not such an issue. All of my queries just use a Pervasive Client DSN. I don't know too much about accessing Pervasive tables from the web and there is most likely a quicker way to access the tables.
All my website code is in ASP and I just run the queries from my ASP code. IS this OK or would it be quicker to write components in VB or something similar to access the tables.
Any help or advice anyone can give me on this would be greatly appreciated.
Thanks in advance.
Mighty
However, we also have a customer portal website where customers can enter orders, check stock, check financial accounts, etc. When I first set up this website over 2 years ago, I found that speed of access to the Pervasive tables was really slow and it could take over 5 minutes in some cases to load pages with complex queries. Obviously this is not acceptable so at the time I set up an MS Access database and run scripts nightly to pull data from Pervasive and store in the Access tables. The obvious drawback of this is that the data displayed on the website is not real time.
2 years on and we are going to try to look at acessing the data directly again. The setup is as follows:
We have a webserver which is quite old but which we hope to upgrade in the near future.
The Pervasive tables are on a seperate server which is newer.
I have a few pages on our Intranet which still accesses the Pervasive table as speed is not such an issue. All of my queries just use a Pervasive Client DSN. I don't know too much about accessing Pervasive tables from the web and there is most likely a quicker way to access the tables.
All my website code is in ASP and I just run the queries from my ASP code. IS this OK or would it be quicker to write components in VB or something similar to access the tables.
Any help or advice anyone can give me on this would be greatly appreciated.
Thanks in advance.
Mighty