Most Effective way to insert into an Indexed field

[Chris Jones]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131115/78089178/attachment.html>