Hey, how about checking how fast your Excel Find and Replace gets when you do it?
Hey, how about checking how fast your Excel Find and Replace gets when you do it?
Yeah, that's what usually happens. A certain program started inside Excel. Time went on, and it kept getting bigger. Finally, it grew too big for Excel to hold. It should have been moved into a proper database instead of staying stuck in the spreadsheet. Excel is actually really good at doing math, but it isn't great at storing lots of data.
So what other things got different this time? Maybe the computer program, maybe the internet connection, or something like that.
Your computer has stayed the same for over a year, even after upgrading from an older CPU to a new one in January 2020 and buying more RAM in June of that same year. You also installed Excel 2016 back in the middle of this year. The internet connection is still fine; it's been all 10 gigabytes since late 2019.
In spreadsheets, you started with formulas up to row 1840 on version 7, then added more rows for a future year by going up to version 8 and reaching row 2000. Over the last two years, because of strict rules or lockdowns, I only checked about twenty-five times instead of one hundred fifty per year. So, even though there are way more rows with data now than before, the actual changes in numbers aren't that big.
I've been trying to get MySQL working with ColdFusion 10 for a while. I can't afford to upgrade my license because it's old and doesn't support community versions of MySQL, which is needed here. All the database tables are already set up, and all the data is inside them; I just can't connect them in this way.
I remember when I tried something similar back a couple of years ago and gave up on that project because it was too hard. Now I have Server 2012 R2 running again, and MySQL version 5.7.35 working fine with ColdFusion 10 (which is the only version you actually own).
So, everything started to work right away when I put both things back together! The old problems about big file transfers on Server 2019 are all gone now. Everything is running smoothly again, and honestly? It's a lot of fun stuff!