Most Effective way to insert into an Indexed field

[Ruslan Zasukhin]

On 11/14/13, 2:58 AM, "Chris Jones" <cjones at daz3d.com> wrote:

Hi Chris,

> 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.

Do you send record by record to remote server?

If yes, then you can try send 10-100 records at once.
E.g. As 

     INSERT(); INSERT(); INSERT();



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]