Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options not deleted
user 163078
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
0
votes
Searching large dataset, best way to speed this up
I'd do a JOIN instead of the the inner query. That is still costly, but it's done once for all entries instead of once per entry.
Only problem would be that you might get duplicates IF multiple rows i …
- 121
2
votes
Is a join faster with 5 tables joined together Or 5 separate queries?
It depends!
on:
what is your bottleneck
database speed / computation power
transfer speed / bandwitdth
application computation power
application main memory
which indices are present
are the join …
- 121