<div>Hi Nick, </div>
<div> thanks for the quick reply. I dont have the sample code with me right now. I will share it with you as soon as possible. I have used the following functions in my sample code.</div>
<div> </div>
<div>SQLAllocHandle</div>
<div>SQLPrepare</div>
<div>SQLExecute</div>
<div>SQLExecDirect</div>
<div> </div>
<div>
<div>SQLPrepare, SQLExecute functions are used when executing the same query multiple times. </div>
<div> </div>
<div>For example insertion or updation of multiple records.</div>
<div> </div>
<div>I have also used transaction when dealing with multiple records</div>
<div> </div>
<div>SQLExecDirect function is used to execute a query single time.</div>
<div> </div></div>
<div>I am actually looking at optimizing the odbc driver for SQLite and driver manager where ever possible to improve the performance rather than optimizing the aplication (assuming that the application is optmized).</div>
<div> </div>
<div>regards,</div>
<div>Siddeswar.</div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Dec 9, 2008 at 3:22 PM, Nick Gorham <span dir="ltr"><<a href="mailto:nick@lurcher.org">nick@lurcher.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div></div>
<div class="Wj3C7c">Siddeswar Reddy wrote:<br><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi Every One,<br> I am new to programming with unixODBC. I have written a sample<br>application for SQLite3 (using SQLite3 native API's) and ODBC (using ODBC<br>
API's, I have used the ODBC driver for SQLite3) to test their performance.<br>It is found that the performance results of ODBC is far less than the<br>SQLite3. I understand that we cannot expect ODBC performance to be same as<br>
that of SQLite3 due to the fact that more functions are invoked by Sample<br>application to acces the data source and work on it. I am looking at<br>optimizing the ODBC Driver Manager and also the ODBC Driver for SQLite3 so<br>
as to bring the ODBC performance to comparable levels with SQLite3 (using<br>native API's).<br><br>I am using the following versions for this experiment<br><br>unixODBC-2.1.12<br>sqlite3odbc-0.78<br><br>The Sample application creates a table and inserts entries into it, updates<br>
few entries, query records, delete the records. It does the same job with<br>both ODBC and SQLite3.<br><br>I am looking for some help in this regard..........<br><br>regards,<br>Siddeswar.<br><br> <br></blockquote></div></div>
Hi,<br><br>At the end of the day, most of this will be down to the driver, but there may be better ways of doing things, show us the sample code and there might be some suggestions.<br><br>Do you mean version 2.1.12 of unixODBC or 2.2.12?<br>
<font color="#888888"><br>-- <br>Nick<br>_______________________________________________<br>unixODBC-support mailing list<br><a href="mailto:unixODBC-support@mailman.unixodbc.org" target="_blank">unixODBC-support@mailman.unixodbc.org</a><br>
<a href="http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support" target="_blank">http://mailman.unixodbc.org/mailman/listinfo/unixodbc-support</a><br></font></blockquote></div><br>