Reply to thread

Message

<blockquote data-quote="Anthony Vaughan" data-source="post: 1286652" data-attributes="member: 153283">I'm not using SQLiteClient - I'm using Entity Framework and LINQ. However, I have converted some SQLiteClient code because we still need some old code in MP - because of dynamic queries. They now connect - do stuff - disconnect; and there is no performance issue. As a user you simply wouldn't notice.But, even when I used SQL, back in 1994, with stored procedures or in-line SQL, I did a project where I was tasked with testing the difference between Oracle connects first time and subsequently. The first connect always took a while and all connects after that were quick. I'm talking about connect - do stuff - disconnect - every time. Once you've done the first connect all connects thereafter are pretty much negligible, performance wise.The same is true for SQLBase, SQL Server and now, in my experience, SQLite.You're not the first person I have heard saying that <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile&nbsp; &nbsp; :)" loading="lazy" data-shortname=":)" /> .</blockquote>

[QUOTE="Anthony Vaughan, post: 1286652, member: 153283"] I'm not using SQLiteClient - I'm using Entity Framework and LINQ. However, I have converted some SQLiteClient code because we still need some old code in MP - because of dynamic queries. They now connect - do stuff - disconnect; and there is no performance issue. As a user you simply wouldn't notice. But, even when I used SQL, back in 1994, with stored procedures or in-line SQL, I did a project where I was tasked with testing the difference between Oracle connects first time and subsequently. The first connect always took a while and all connects after that were quick. I'm talking about connect - do stuff - disconnect - every time. Once you've done the first connect all connects thereafter are pretty much negligible, performance wise. The same is true for SQLBase, SQL Server and now, in my experience, SQLite. You're not the first person I have heard saying that :) . [/QUOTE]

Verification