The .NET code is identical, just the connection string is different:
Server (specifies a computer and a port):
"Database=C:\msc\timeSnapper\v2.0\bin\TimeSnapper.fdb;
Userid=SYSDBA; Password=masterkey; DataSource=localhost; Port=3050;
ForcedWrite=true"
Embedded (ServerType=1 which says it's embedded):
"Database=C:\msc\timeSnapper\v2.0\bin\TimeSnapper.fdb;
Userid=SYSDBA; Password=masterkey; ServerType=1; ForcedWrite=true"
That is the only difference. I would think cross process intercommunications would be more expensive then some PInvoke calls!
On 1/10/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello:
> When I'm running the query through the server, the query
takes like
> 0.1 sek but one second when I connect using the embedded
version
Well have in mind that when running a select query against the
embedded server
the rows are fetched one by one that means that there
will be tons of PInvoke calls
(the pinvoke is a simple way to
implement the embedded server support but it has a
performance penalty
in every call)
When you tell "I'm running the query through the
server," what do you mean ??
using isql ??
Can you send a test case
to show what you are doing ??
--
Best regards
Carlos Guzmán Álvarez
Vigo-Spain
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&opclick
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
