sde
Well-known member
Im currently in the planning stages of developing .net windows applications for various uses around our company.
These applications will be accessing our customer data which resides in a DB2 database which resides in an iSeries server. The database currently holds about 500k contacts, but this should at least double in the near future.
Ive run tests using OleDB, ODBC, and even third party drivers, and the results are still extremely slow.
Now Im looking into web services such as soap. Im thinking of just creating a dataset on the service application which will generate much quicker results to the client machines accessing the customer data. ( this brings a whole nother level of questions not related to this topic )
Im just wondering what the best way to deal with Large Datbases and deveooping multi-tier applications which need quick access to the data.
Any thoughts?
These applications will be accessing our customer data which resides in a DB2 database which resides in an iSeries server. The database currently holds about 500k contacts, but this should at least double in the near future.
Ive run tests using OleDB, ODBC, and even third party drivers, and the results are still extremely slow.
Now Im looking into web services such as soap. Im thinking of just creating a dataset on the service application which will generate much quicker results to the client machines accessing the customer data. ( this brings a whole nother level of questions not related to this topic )
Im just wondering what the best way to deal with Large Datbases and deveooping multi-tier applications which need quick access to the data.
Any thoughts?