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.

Sign up for GitHub

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

Jump to bottom

implement table index hints via useIndex argument #864

Closed
chapmandu opened this issue May 22, 2018 · 1 comment
Closed

implement table index hints via useIndex argument #864

chapmandu opened this issue May 22, 2018 · 1 comment
Assignees
@chapmandu
Labels
docs enhancement
Milestone
2.2.0

Comments

@chapmandu
Copy link
Contributor

enable a useIndex argument in findAll:

model("author").findAll(
	include="posts",
	useIndex={
		author="idx_authors_123",
		post="idx_posts_123"
	}
);

useIndex accepts a structure of strings.

Only MySQL and SQLServer support index hints. It would be ignored (or throw exception?) for unsupported dbs.
chapmandu added a commit that referenced this issue May 22, 2018
@chapmandu
implement table index hints (#864)
41be2ea 
* allow skipping db populate during reload

* 864-implement-table-index-hints

* simplify populate logic

* ACF semicolon fix

* adds docs for useIndex
@chapmandu chapmandu added the docs label May 22, 2018
@neokoenig neokoenig added this to the 2.1.0 milestone May 23, 2018
@chapmandu chapmandu self-assigned this Sep 21, 2018
@neokoenig neokoenig modified the milestones: 2.1.0, 2.1.1 Feb 24, 2020
@neokoenig neokoenig modified the milestones: 2.1.1, 2.2.0 Apr 12, 2020
@neokoenig
Copy link
Contributor

Docs updated https://guides.cfwheels.org/docs/reading-records#useindex-argument

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@chapmandu chapmandu

Labels
docs enhancement
Projects
None yet
Milestone
2.2.0
Development

No branches or pull requests
2 participants
@neokoenig @chapmandu