Most Effective way to insert into an Indexed field

[Chris Jones]

Hi,

I am running into a slow down when I try to insert about a 100 records into
a table.  The table has only one column, a var char, and has a unique index
on that column.  The test table I am working with has about 320000 records
currently in it.  Also I am accessing the database as a client ( db is
running as a service).

Is there a better way to do this than "AddRecord" on a table object?  I
need to ensure that the inserted items are unique and quickly searchable,
hence the unique index.  Thank you for any help.
-- 
Christopher Jones
Software Developer
DAZ 3D
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131113/532fb9ef/attachment.html>