- Joined
- Jan 1, 2009
- Messages
- 15,526
- Reaction score
- 3,891
- Points
- 113
- Location
- Winchester, VA
- Your Mac's Specs
- MBP 16" 2023 (M3 Pro), iPhone 15 Pro, plus ATVs, AWatch, MacMinis (multiple)
Patrick, it reminds me of an event when I worked at a major university. We had installed an application that used Oracle as the database to track our students. We tracked all current students, all former students, all graduates, all applicants, all alums, no matter how long it had been. So our "student" database had a couple of million records in it. We got a data input from the college boards of the score of all test-takers who had indicated interest in that university, about 250,000 records monthly. The first time we ran the merge, it ran forever. We called the vendor and talked with the programmers. They said they had a routine in the merge to make sure that a new record was never created if there was a record already there (which is a good thing) but that the routine had to take into account the many variations in the name (initials, nicknames, marriages, divorces, adoptions, you name it). We asked if they had tested it and they said they had. We asked for details, were told they had merged 3 names into a database of 10 names and the job finished in 7 minutes. When we pointed out that 7 minutes to merge 3 into 10 isn't a good thing, they said nobody had ever complained before.
So my DBA spent a weekend, wrote a new routine that did the same merge of 250,000 into our huge database in three minutes. We sent it to the vendor's developers who basically said, "not built here" and dismissed it.
So I suspect that if Apple tested, it was with a couple of pictures and one face. Nothing like reality.
I don't want to mess with it at this point. I may look at a reinstall or to whack some plists once it's done, but for now, I'll let it chug. I don't shut down the Mac, so it has the full machine overnights, but it doesn't seem to want any CPU at all.
So my DBA spent a weekend, wrote a new routine that did the same merge of 250,000 into our huge database in three minutes. We sent it to the vendor's developers who basically said, "not built here" and dismissed it.
So I suspect that if Apple tested, it was with a couple of pictures and one face. Nothing like reality.
I don't want to mess with it at this point. I may look at a reinstall or to whack some plists once it's done, but for now, I'll let it chug. I don't shut down the Mac, so it has the full machine overnights, but it doesn't seem to want any CPU at all.