fastest way to insert one record into a table

From: Thomas Mueller (news_at_s2h.cx)
Date: 07/10/04 

Date: Sat, 10 Jul 2004 19:33:55 +0200

Hi,

what is the fastest way to insert one record into a table? I have got one
table of about 20 fields which is written to regularly. But every time
there will only be a single record added to it. One problem here is that
not all fields will be filled every time but some can remain NULL.

What is the fastest way to do this? Use a TAdoQuery with TableDirect = true?
An TAdoCommand with an insert statement (but how would that handle the
empty fields?)? A TAdoTable? Server- or ClientSide cursor? Any other
settings?

There are no components associated with this table.

Currently I use a TAdoTable object with a server side cursor which is opened
in startup and remains open until the program closes. This seems to be
quite slow. I have already called DisableComponents, what else can there be
done?

twm