I work for a company that despite using a significant amount of IT does not have a dedicated skilled internal IT support department, and the following problem has been dropped in my lap, which I’m hoping someone could help me with:
We’re currently using an AIX box running a bespoke stock management/order tracking system and an IIS web server. The system is ODBC compliant, and we were going to allow our customers to track their shipments via the web using ASP/SQL.
However, the estimated amount of queries is quite high and could affect the performance of the AIX box and bespoke software, which is not acceptable.
We have SQL Server 7, and I was wondering if it’s possible to set up it up so that all web requests go to the SQL Server, and only have the server query the AIX box, say every 5 minutes.
I’d appreciate any comments on the practicality of this method, and also a pointer as to where I could find information on how to do this.
I’ve not used any version of SQL Server before, but as far as I know it has already been installed on a machine with the relevant DSN’s set up, but I think that’s about it.
Thank you.
We’re currently using an AIX box running a bespoke stock management/order tracking system and an IIS web server. The system is ODBC compliant, and we were going to allow our customers to track their shipments via the web using ASP/SQL.
However, the estimated amount of queries is quite high and could affect the performance of the AIX box and bespoke software, which is not acceptable.
We have SQL Server 7, and I was wondering if it’s possible to set up it up so that all web requests go to the SQL Server, and only have the server query the AIX box, say every 5 minutes.
I’d appreciate any comments on the practicality of this method, and also a pointer as to where I could find information on how to do this.
I’ve not used any version of SQL Server before, but as far as I know it has already been installed on a machine with the relevant DSN’s set up, but I think that’s about it.
Thank you.
