Re: ESQL vs. database APIs

Jim Carlisle wrote: > > We are considering whether or not to code our C language database > applications in Embedded SQL instead of using the native API calls > (currently Sybase Open Client). Does anybody have an opinion on which > method is better? > > Our initial testing shows the APIs to have much better performance than > the ESQL programs but we are also concerned about portability between > hardware platforms (RS/6000, AS/400, NT), migrating to different > databases (Oracle, Informix, etc...), and programmer considerations (ease > of use, learning curves, etc...). > > Any help would be much appreciated. > > Thanks, > Jim Carlisle One of the biggest problems with ESQL is performance. Another problem is the fact that your client will be "fat". This may be problem when you are considering upgrading the functionality of the client. In regards to compatibility is there not much difference between ESQL and database API's. All the DBMS vendors have their own library's and dialects of SQL, so when you move from one vendor to another you always have to migrate your code. ESQL is very easy to step in. I hope this is somewhat helpfull. Jacob de Rotte - jacobr@infosup.nl Info Support b.v. The Netherlands www.infosup.nl