Blob Performance

From: F.Stockmann (nospam_at_nospam.com)
Date: 01/23/04 

Date: Fri, 23 Jan 2004 12:27:15 +0100

Hi,
I use a TADOTable with an TADOConnection on a MSDE / MSSQL DB.

When I load a 33MB File in a Blobfield (TBlobfield.LoadFromFile) i takes
60sec.
A test with Firebird only takes 20sec.

What can I do to tune the Blob performance beside switching to Firebird
(customer requierements) ?

By

Relevant Pages

  • Re: Best database for a software package
    ... - If you want a delphi-centric solution, I would choose DBISAM or NEXUSDB. ... for single user apps. ... IBX with FIREBIRD 1.5 or below or directly FIBPlus or IBOBJECTS. ... MSSQL, via ...
    (borland.public.delphi.non-technical)
  • Re: Compiler Directives
    ... gotslack wrote: ... {$define FIREBIRD}; ... {$define MSSQL}; ... use If Conditional Statements instead? ...
    (comp.lang.pascal.delphi.components.writing)
  • Re: Compiler Directives
    ... {$define FIREBIRD}; ... {$define MSSQL}; ... function SQLTopClause: String; ... use If Conditional Statements instead? ...
    (comp.lang.pascal.delphi.components.writing)
  • Re: Guild Wars: Best graphics for an MMORPG?
    ... >>> Not to quibble but, With firebird it didn't load, and flash IS ... I don't know what 'firebird' is. ...
    (comp.sys.ibm.pc.games.rpg)
  • Re: Firebird slowness
    ... > Open two tabs in Firebird, and ask it to load different pages ... On Linux and Windows, it does that simultaneously as you ...
    (comp.unix.bsd.freebsd.misc)