Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Batch indexing (multiple inserts) #14

Open
leodido opened this issue Feb 14, 2014 · 2 comments
Open

Batch indexing (multiple inserts) #14

leodido opened this issue Feb 14, 2014 · 2 comments
Assignees
Milestone

Comments

@leodido
Copy link
Contributor

leodido commented Feb 14, 2014

Support SphinxQL multiple row insertion.

The INSERT syntax to achieve this task is explained by following example:

INSERT INTO rt_index [(col_a, col_b)] VALUES
    (val_a1, val_b1),
    (val_a2, val_b2)
    [, (...)]

Documentation says that

Multiple rows can be inserted using a single INSERT statement by providing several comma-separated, parentheses-enclosed lists of rows values.

This behaviour is available also for REPLACE statement.

Reference here.

@leodido leodido modified the milestones: Version 0.5.0, Version 0.7.0 Feb 14, 2014
@leogr leogr removed this from the Version 0.7.0 milestone Mar 24, 2014
@leogr leogr added this to the Version 0.7.0 milestone Apr 13, 2014
@leogr leogr self-assigned this Apr 13, 2014
@leogr
Copy link
Contributor

leogr commented Apr 13, 2014

zendframework/zendframework#4028

I think it's specific of some SQL dialect so it makes sense to implement this functionality in our library.
I'll do that.

@leodido
Copy link
Contributor Author

leodido commented Apr 14, 2014

This is not the only way to index multiple documents at once but it is the most efficient.
Reference here, 2nd part.

👍

@leodido leodido changed the title Bulk indexing Batch indexing Apr 14, 2014
@leodido leodido changed the title Batch indexing Batch indexing (multiple inserts) Apr 14, 2014
@leodido leodido modified the milestones: Version 0.7.0, Version 0.8.0 Sep 30, 2014
@leogr leogr modified the milestones: Version 0.8.0, 0.9.0 Jun 22, 2015
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants