Post Av9pV6FPxbfawUHeBU by [email protected] | |
More posts by [email protected] | |
Post #Av9ebHjR4nqAnl4T9k by [email protected] | |
0 likes, 0 repeats | |
Me: Spends hours optimizing a database query.Solution: Adding an index.Dev life… | |
Post #Av9ekBNY4AJzhj4mg4 by [email protected] | |
0 likes, 0 repeats | |
@nixCraft did you try to explain the query to see the execution plan and what c… | |
Post #Av9fSr1KbYR3axz9cW by [email protected] | |
0 likes, 0 repeats | |
@nixCraft The proper DevOops approach is to just keep increasing the instance s… | |
Post #Av9fftNx7id6h6md3g by [email protected] | |
0 likes, 0 repeats | |
@nixCraft Company: Dear consultant, $10,000 is awfully expensive for just creat… | |
Post #Av9fjFMNsWxtiTeJUW by [email protected] | |
0 likes, 0 repeats | |
@nixCraftMe: "Nah, I don't need an index on this. It's simple data… | |
Post #Av9hC9eKI086MDODvk by [email protected] | |
0 likes, 0 repeats | |
@nixCraftClient: Spends days trying to optimise query, add indexes, trace code,… | |
Post #Av9n680A6Pb5Ea737w by [email protected] | |
0 likes, 0 repeats | |
@nixCraft That's why #Octo (docs.yottadb.com/Octo) automatically creates in… | |
Post #Av9pV6FPxbfawUHeBU by [email protected] | |
0 likes, 0 repeats | |
@nixCraft I'm surprised autocorrect didn't change "SQL life" … | |
Post #AvAB7rEZoQbci4DFIG by [email protected] | |
0 likes, 0 repeats | |
@nixCraft 过早优化是万恶之源。 | |
Post #AvAK4XL2E9hxiriztA by [email protected] | |
0 likes, 0 repeats | |
@nixCraft I don't know why so many people use SQL database. Most software u… | |
Post #AvBCrTFRcO0qketOAi by [email protected] | |
0 likes, 0 repeats | |
@nixCraft SQLife | |
Post #Axq3QRXMiUNqTzRvHc by [email protected] | |
0 likes, 0 repeats | |
@bhaskar How about insert/update overhead and space requirements? This could al… | |
Post #Axq3QReoGoL2r4vrt2 by [email protected] | |
0 likes, 0 repeats | |
@theodore You can always run a DISCARD XREFS (https://docs.yottadb.com/Octo/gra… |