Re: Database for C#

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: DalePres (don-t-spa-m-me_at_lea-ve-me-a-lone--.com)
Date: 07/10/04 

Date: Sat, 10 Jul 2004 09:56:38 -0500

If I needed absolute top performance without installing something like MSDE
or SQL Server, I would write a simple binary tree system and make your own.
It is the only way you're going to get great performance.

The problem you're going to have isn't in the fact that the other options,
Access, FoxPro, etc. are file based systems; SQLServer uses disk files to
store data too. The problem is the access methods; ODBC, ADO, etc. are just
too slow when accessing file based systems while, with SQL Server, ADO, etc.
mostly just communicates with the server.

So, while I recommend using MSDE for a client application that requires
better performance than Access, if that just is not a possibility, roll your
own. Writing a simple, application specific, b-tree system is not very
difficult. You only need a handful of methods:

Search a node (recursively),
Add a node,
Delete a node,
Split a node
Create a child node

with those and probably just a few more, you could create your own lightning
fast, application-specific, database system.

Years ago, circa 1990 or 1991, BYTE magazine had a great article on writing
your own b-tree systems. It included psuedocode for about 10 functions
that, at the time, I built upon to create a complete database system. I
suppose that's not a lot of help now (a quick search of byte.com doesn't
come up with the article) but certainly there's something similar available
on the net.

Dale

"Matthias Kwiedor" <crazyivan9@hotmail.com> wrote in message
news:Xns95229984B5168crazyivan9hotmailcom@207.46.248.16...
> Hi!
>
> In my current Project i use MS Access as Database. I know some Databases
> like SQL Server, Oracle, mySQL and the DB/2 from IBM, but no more "Stand-
> alone" Databases.
>
> Did anyone know a Database, where i can use like MS Access (this means,
> without needing to install a Database like mySQL or SQL Server) and has
> more performance as MS Access? The last time i used MS Access (about 4
> years ago) i had some performance Problems with more than 10.000 Datasets!
>
>
>
> Thanks for your help or/and comments
>
>
>
> Regards
>
> Matthias

Relevant Pages

  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Administering MSDE
    ... Thanks for posting in our newsgroup and also for Costas's input. ... SQL Server Web Data Administrator ... Installing Microsoft Windows Server Update Services 3.0 on Windows Small ... Installing WSUS 3.0 won't affect the SharePoint database. ...
    (microsoft.public.windows.server.sbs)
  • Re: msde2000
    ... Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is the free, ... As for it being better than MS-Access, the answer to that is probable yes, ... MOST other database DO NOT. ...
    (microsoft.public.vc.mfc)
  • Re: Database Connectivity
    ... But, MSDE has been know to work very reliably in small user LANS, ... > just a simple step to attach the tables from MSDE to SQL Server. ... database, or pay for an "industrial-strength" version of it when there ... Don't like Microsoft?, sounds like a personal problem to me. ...
    (comp.lang.python)
  • Re: Theres a new Borland Delphi directions survey up
    ... Choosing and Using MSDE 2000 as the Database Engine for Your Application ... The Microsoft SQL Server 2000 Desktop Engine is an alternative ... database engine in Microsoft Access 2002 which enables software developers ...
    (borland.public.delphi.non-technical)