Timeline for Performance difference between multiple tables and indexed single table
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 10 at 9:41 | comment | added | DamiToma | That's exactly what I was looking for. Thanks! | |
| Feb 9 at 19:56 | history | edited | Rick James | CC BY-SA 4.0 |
added 323 characters in body
|
| Feb 9 at 19:45 | comment | added | Rick James | I added details on indexing. Still more questions? | |
| Feb 9 at 19:44 | history | edited | Rick James | CC BY-SA 4.0 |
added 594 characters in body
|
| Feb 9 at 19:35 | history | edited | Rick James | CC BY-SA 4.0 |
added 594 characters in body
|
| Feb 9 at 19:05 | comment | added | DamiToma | I was more interested in understanding how an index is implemented under the hood. DECIMAL(20, 8) is definitely an overkill for most applications and agreed on the INDEX, sorry about the mistake. The query I'm curious about are normal SELECT queries that fetch a list of candles for a given symbol. Thanks for the help! | |
| Feb 9 at 18:28 | history | answered | Rick James | CC BY-SA 4.0 |