ADO DBExpress Writing multiple records to a database

From: Gregory A. Dunn (gregd_at_eagleresearchcorp.com)
Date: 02/19/04 

Date: Thu, 19 Feb 2004 17:12:48 -0500

Hello,

I am working on a database application which writes large numbers of records
at a time. In all of my attempts, this seems to be an extremely slow
process. I am currently using Microsoft Access but also plan on using this
application with various SQL databases in the future. I have tried ADO and
also DBExpress with the Open Source DBExpress driver for ODBC. I have tried
using Edit/Insert/Append/Post as well as using Update/Insert queries. I have
tried using Caching, ClientDataSets, etc. Some methods showed more
performance that others, but none seemed to be as good as I would like. Can
anyone suggest the most speed efficient way to insert/update multiple
records. Which databases are best for this type of application, Access, SQL
Server, MySQL ...?

Thanks,
Greg Dunn

Relevant Pages

  • Re: How to remove Security from Access 2002
    ... If you want a book entirely on Access security, Real World Microsoft Access ... data manager like myself who knows about databases, ... "Joan Wild" wrote: ...
    (microsoft.public.access.security)
  • Re: Upsizing To SQL Server
    ... to medium size databases to SQL Server? ... updates being copied from the main system to the backup system in under a second. ... And the newspaper ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: Microsoft Access Training
    ... The Code of Conduct governing the use of these newsgroups ... There really is no substitute for learning Microsoft Access from ... I walk you through every step of creating your databases. ... Exchange information with other documents and databases ...
    (microsoft.public.access.gettingstarted)
  • Re: Access/Comcast/Digital Conversion
    ... databases have been in use for 5 years in one instance and 3 years for the ... See the Serial Port Communications page at my web site. ... Database window which does not open. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Access 07 Contemplations
    ... User-Level Security is still available for databases that remain in MDB ... It's not supported in the new ACCDB format. ... You may want to post your comments on the Access Team Blog to let the ... See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. ...
    (comp.databases.ms-access)