<html><head><meta http-equiv="Content-Type" content="text/html charset=iso-8859-1"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><br><div><div>On Nov 14, 2013, at 2:58 AM, Chris Jones <<a href="mailto:cjones@daz3d.com">cjones@daz3d.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">Hi,<div><br clear="all"><div>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).</div>
<div><br></div><div>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.</div></div></div></blockquote></div><div><br></div>One more possibility is to use row-constructor syntax:<div><br></div><div><div style="margin: 0px; font-size: 11px; font-family: Menlo; color: rgb(209, 47, 27);">insert into t1 VALUES (1, '1'), (2, '2') </div><div apple-content-edited="true"><br></div><div apple-content-edited="true">It means - add 2 rows at once:</div><div apple-content-edited="true"><br></div><div apple-content-edited="true">1, '1'</div><div apple-content-edited="true">2, '2'</div><div apple-content-edited="true"><br></div><div>
<span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px;"><div>-- <br>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/">http://www.valentina-db.com</a></div></span>
</div>
<br></div></body></html>