If opponents have only 24-25 points the auction would likely have involved acceptance of a game invitation. Instead there was a jump to game by responder without a slam try, each opponent having 4 cards in a different major; opponents rate to have 29 points +- 3. You have 8 points in hand, giving partner 3 points +- 3. The likelihood of being able to set up and run a suit in partner's hand is extremely remote.
However if partner has QTx in diamonds and an entry you might be able to win a race against Declarer in that suit. Lead your fourth best diamond as was actually done at the table. This also gives partner a clear signal as to what to lead back to you when he gets in the (probably) one only time that happens.
On this particular hand I see no reason for method of scoring to matter, but as a matter of good form it should be specified.
It is important to note also that partner is going to be squeezed in both Majors. Clubs are splitting 3-3 for Declarer. Combined with the fact that opponents jumped to game rather than accepting an invitation, at Matchpoints I am going to be happy to get four defensive tricks for Average plus against all those who make an overly aggressive, and desperate, attempt to find unavailable tricks in partners hand. Even sitting patiently for my third defensive trick will often be a good Matchpoint result on this hand.
In short, to answer your specific question: No, it is pointless to search for major suit tricks on this auction. Partner has neither the suit strength nor the entry to make searching for his suit profitable. The only chance to set this hand is a miracle of clashing honours for opponents, and even then you will have to have set up cashing tricks in your hand to collect on the good fortune.
Revisiting this, the biggest problem with a Spade lead are that these three scenarios are most likely:
Partner wins the Spade lead and returns it, setting up his Spade winners. You now have no more entries to partner's tricks, and have lost two tempos for setting up Diamonds.
Partner wins the Spade lead but sees no future in the suit, and makes a random guess as to which minor to return guessing wrong 50% of the time. Either one or two tempos for setting up diamonds have been lost.
Partner has Qxxx or Jxxx unsupported in Spades and you have just guaranteed Declarer four Spade tricks and the contract.
Potentially settable Notrump contracts are a race between Declarer and Defense, and the loss of even a single tempo nearly always guarantees losing that race. It is imperative for the Defense to chase long-suit tricks in the hand with entries. Here, it is very unlikely that Partner can have enough points both to make Spades worth setting up and have an entry making them cashable.
Form of Scoring:
In Rubber (as here) of IMPS one always makes an extreme effort to set the contract, as overtricks are very rarely of import. Lead a diamond.
In Matchpoints, one is looking to not get a bottom on the opening lead. Experience has taught me that leading from jack empty fourth is a nearly guaranteed bottom - but leading from jack empty fifth or longer is often a winning play. The decision is now more complex. It is possible that Partner's Spade trick is dead unless you lead the suit now, so that lead might be right. I am personally an aggressive defender, so would usually lead a Diamond, but would accept a Spade lead from partner as reasonable.