Most Effective way to insert into an Indexed field

[Chris Jones]

In a related manner, if one insert in the list throws an exception will the
list stop processing or will it finish?


On Fri, Nov 15, 2013 at 8:05 AM, Chris Jones <cjones at daz3d.com> wrote:

> Is there a way to do multiple inserts with "binding" or is it not a case
> where it will help?  Or in other words, does the sql parser match the whole
> list for its pool or is it smart enough to do individual pieces.
>
>
> On Fri, Nov 15, 2013 at 4:05 AM, Ruslan Zasukhin <
> ruslan_zasukhin at valentina-db.com> wrote:
>
>> 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]
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>
>
>
> --
> Christopher Jones
> Software Developer
> DAZ 3D
>



-- 
Christopher Jones
Software Developer
DAZ 3D
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131115/6be7aa59/attachment.html>