Help: choosing a database engine for MS-Windows

Hi,

        We are using MFC(VC++ 1.51) to develop our MS Windows application. Currently, the database engine we are using is WatCom SQL for Windows, which is a standalone 32-bit SQL database for single user and supports ODBC, Embedded SQL and WSQL HLI(High Level Interface). We used to use ODBC to access the database but it was very slow; then we switched to WSQL HLI. It seems we got faster database access but we sometimes have database connection problems if there are multiple database connections.

        We really have some problems with WatCom SQL for Windows, besides they charge you $75 per question. We may need to choose a different database engine. We don't know much about what is available and better on the market, so we would like to ask some questions.

1. MS ODBC is really nice but it is very slow. Do you use ODBC and if yes how do you improve the database access performance?
2. What do you think about WatCom SQL for Windows if you have had experiences with it?
3. Is there any better database engine for the single user and how is its database interface?
4. How faster would it to use Embedded SQL insteal of ODBC?

Thanks a lot!!!

Shao Received on Fri Mar 17 1995 - 20:54:41 CET