Click here to Skip to main content
15,877,618 members
Home / Discussions / Database
   

Database

 
GeneralRe: ExecuteScalar with COUNT causes Exception? Pin
Pauwll13-Nov-03 5:07
Pauwll13-Nov-03 5:07 
GeneralPutting fixed array into DB field Pin
EddieSD647-Nov-03 11:31
sussEddieSD647-Nov-03 11:31 
GeneralStored Procs, parameters and IN Clause Pin
stephen woolhead7-Nov-03 5:00
stephen woolhead7-Nov-03 5:00 
GeneralRe: Stored Procs, parameters and IN Clause Pin
jeff_martin11-Nov-03 12:04
jeff_martin11-Nov-03 12:04 
GeneralSQL Server does not exist or access denied Pin
yyf7-Nov-03 2:50
yyf7-Nov-03 2:50 
GeneralProblem with _Connection::Open ! Pin
nigs_krec7-Nov-03 1:53
nigs_krec7-Nov-03 1:53 
GeneralManaged .NET Embedded Database Pin
Andrew Shapira6-Nov-03 10:11
Andrew Shapira6-Nov-03 10:11 
GeneralRe: Managed .NET Embedded Database Pin
Mike Dimmick7-Nov-03 2:54
Mike Dimmick7-Nov-03 2:54 
Why do you care? Is there something that Jet can't do that you need to do?

While a wholly-managed application doesn't incur any interop overhead, a P/Invoke call (to a flat API) only has about 10 machine instructions overhead, while a COM Interop call has about 50 machine instructions overhead (source: Managed/Unmanaged Code Interoperability[^]. Some people have reported that ODBC connections from ADO.NET (using System.Data.Odbc classes in Framework 1.1, or Microsoft.Data.Odbc from the download for Framework 1.0) perform better than OLE DB connections.

If you're doing anything serious with the database, though, the interop overhead is likely to be swamped by the cost of actually reading and writing to files, and looking up records in indexes.

If you need your application to be portable across CLI implementations (and across operating systems) then you will have to consider an alternative.

'Pure managed' code on .NET is far less important than for Java, where performance with unmanaged code is reportedly poor.
GeneralRe: Managed .NET Embedded Database Pin
Andrew Shapira7-Nov-03 10:17
Andrew Shapira7-Nov-03 10:17 
GeneralRe: Managed .NET Embedded Database Pin
Arjan Einbu10-Nov-03 11:01
Arjan Einbu10-Nov-03 11:01 
GeneralRe: Managed .NET Embedded Database Pin
Andrew Shapira10-Nov-03 13:57
Andrew Shapira10-Nov-03 13:57 
GeneralMax Pool Size's Limitation Pin
yyf6-Nov-03 8:43
yyf6-Nov-03 8:43 
GeneralCreating a DBASE file Pin
DonBush6-Nov-03 4:04
DonBush6-Nov-03 4:04 
GeneralRe: Creating a DBASE file Pin
Jörgen Sigvardsson6-Nov-03 14:00
Jörgen Sigvardsson6-Nov-03 14:00 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 2:33
DonBush7-Nov-03 2:33 
GeneralRe: Creating a DBASE file Pin
Jörgen Sigvardsson7-Nov-03 3:14
Jörgen Sigvardsson7-Nov-03 3:14 
GeneralRe: Creating a DBASE file Pin
DonBush7-Nov-03 4:10
DonBush7-Nov-03 4:10 
GeneralRe: Creating a DBASE file Pin
Arjan Einbu10-Nov-03 11:07
Arjan Einbu10-Nov-03 11:07 
GeneralRe: Creating a DBASE file Pin
DonBush11-Nov-03 2:47
DonBush11-Nov-03 2:47 
QuestionMust be a permissions thing, but what? Pin
Colin Angus Mackay6-Nov-03 4:04
Colin Angus Mackay6-Nov-03 4:04 
Answer(Actually it wasn't) Pin
Colin Angus Mackay6-Nov-03 5:33
Colin Angus Mackay6-Nov-03 5:33 
GeneralRe: (Actually it wasn't) Pin
Michael Dunn6-Nov-03 13:01
sitebuilderMichael Dunn6-Nov-03 13:01 
GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson6-Nov-03 13:58
Jörgen Sigvardsson6-Nov-03 13:58 
GeneralRe: (Actually it wasn't) Pin
Colin Angus Mackay7-Nov-03 1:37
Colin Angus Mackay7-Nov-03 1:37 
GeneralRe: (Actually it wasn't) Pin
Jörgen Sigvardsson7-Nov-03 3:11
Jörgen Sigvardsson7-Nov-03 3:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.