Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for Charlie Brumbaugh
Type | On... | Excerpt | Status | Date |
---|---|---|---|---|
Comment | Post #282203 |
@Culyx because joining to a concatenated field of 5 columns is faster than to the 5 columns one at a time. (more) |
— | almost 3 years ago |
Comment | Post #279113 |
So this way will lock up the DB for a while, and avoiding the locks is the whole point of using PHP and doing it in sections (more) |
— | over 3 years ago |
Comment | Post #279035 |
Each column had a unique key, not a unique key on the combination (more) |
— | over 3 years ago |
Comment | Post #278899 |
@Alexei my point being that leaving this open if the command was in a bash script and closing it if just running from the command line seems very arbitrary. If I add "In my bash script " to the front of the question, does that make it on-topic? (more) |
— | over 3 years ago |
Comment | Post #278899 |
@Alexei Would using a zip program in a PHP script to archive folders after downloading data from a DB be on topic? In other words does the OP just need the right context to ask the question? (more) |
— | over 3 years ago |
Comment | Post #278837 |
Is that a ```goto``` ಠ_ಠ ? (more) |
— | over 3 years ago |
Comment | Post #278292 |
@Alexei I don't think its the reports, but rather inserts crossing paths with the selects. The reports used to cause locks, but that was fixed by breaking the queries into chunks and then doing the calculations outside of the DB. (more) |
— | over 3 years ago |
Comment | Post #278211 |
We could create a category for self answers, it annoying when you self answer and then get comments on the question remarking how you should have done more research (more) |
— | over 3 years ago |
Comment | Post #278207 |
The problem with doing it in a development environment first is that it doubles the time (more) |
— | over 3 years ago |
Comment | Post #277833 |
@Monica I mean the solution works regardless of whether you are disabling a bunch or just one user (more) |
— | over 3 years ago |
Comment | Post #277469 |
@Alexi alter table example change old_name new_name data_type; (more) |
— | over 3 years ago |
Comment | Post #277470 |
The more data a table has in it, the longer it takes to rename the column (more) |
— | over 3 years ago |
Comment | Post #277373 |
@meriton that page is useful for calculating how much space adding other int column with all rows filled will take, less useful for how much space a varchar column where the length of the strings is not constant (more) |
— | over 3 years ago |
Comment | Post #277373 |
@jcsahn InnoDB, yes (more) |
— | over 3 years ago |
Comment | Post #277148 |
@ArtofCode sometimes when doing sub queries like this it has to have a unique alias and it's easier to just always do the double select and copy paste that (more) |
— | over 3 years ago |
Comment | Post #277148 |
@manassehkatz The query cost is slightly different but the results are not (more) |
— | over 3 years ago |