Hi Friends,
Currently we have our commecial systems running on Oracle 8.0. The whole oracle database size is
9 GB, and the data size is about 4 GB. There are about 50 concurrent users. Is it possible to shift the Oracle database to PGSQL. Also we have offices at different locations other than our main office. They are connected to the main office by 64 kbps lines. Currently the number of transactions are about 2500 per day.
If we shift our Oracle/Win NT database to PGSQL/Linux then we have following querries:
1> Whether is it advisable to develop an ERP (mid-sized) application using PGSQL.
2> Is it possible to develop an ERP like application (Web Enabled) so that we can have
centralised database at our main office and our remote branch offices will connect to it via
WAN links.
3> How many concurrent users can connect to PGSQL database either local or remote. If there are
more than 100 users will it affect the performance of the database ?
4> What is the recommended Front-End for PGSQL, which can be accessed through a browser ?
5> What is the report-writing tool for PGSQL ?
Waiting for your reply
Yours
Swati
Currently we have our commecial systems running on Oracle 8.0. The whole oracle database size is
9 GB, and the data size is about 4 GB. There are about 50 concurrent users. Is it possible to shift the Oracle database to PGSQL. Also we have offices at different locations other than our main office. They are connected to the main office by 64 kbps lines. Currently the number of transactions are about 2500 per day.
If we shift our Oracle/Win NT database to PGSQL/Linux then we have following querries:
1> Whether is it advisable to develop an ERP (mid-sized) application using PGSQL.
2> Is it possible to develop an ERP like application (Web Enabled) so that we can have
centralised database at our main office and our remote branch offices will connect to it via
WAN links.
3> How many concurrent users can connect to PGSQL database either local or remote. If there are
more than 100 users will it affect the performance of the database ?
4> What is the recommended Front-End for PGSQL, which can be accessed through a browser ?
5> What is the report-writing tool for PGSQL ?
Waiting for your reply
Yours
Swati