What does "in-proc database" mean?

[jonfroehlich]

On Sriram Krishnan's blog he writes, "Sql Mobile is a
super-lightweight, in-proc database that runs on devices. The key
phrase for me personally is 'in-proc'. This means that there is no IPC
involved and as a result, performance is blindingly fast."

This is really the only discussion I could find about in-proc databases
via a quick Google search. Can anyone provide me with any more
information on what an "in-proc database" is and how it differs from an
"out-of-proc?" database. The implication of Sriram's post is that
SqlMobile is efficient because it doesn't use interprocess communcation
(assuming that's what IPC stands for). Do most databases use IPC?

Thanks!

Jon

[Ginny Caughey [MVP]]

Sure, Jon. Some databases such as SQL Server run as services in their own
process space, often on a different machine from the apps that consume those
services. Others such as SQL Server Everywhere/SQL Mobile are DLLs that run
in the same process space as the application that uses them. Not only does
this imply that there is no process boundary to impact perforamance, but
also when the hosting application ends, so does the database engine so there
is no service running to serve as a potential security threat. There are
advantages to client/server databases such as SQL Server, but for
stand-alone and mobile apps, there are also advantages for an in-process
database such as SQL Mobile/Everywhere.

If you want more information, just ask...

--
Ginny Caughey
Device Application Development MVP

"jonfroehlich" <jonfro...@gmail.com> wrote in message
news:1152997722.6...@p79g2000cwp.googlegroups.com...

[jonfroehlich]

Thanks for clearing this up, Ginny. I appreciate it.

j