So how many sat/vB do you use so you have to wait two weeks to wait for confirmation?
I don't think this is a great experience because anyone who sends bitcoins at a low cost then they have to wait for a longer block confirmation, but if you adjust the fees with the mempool then the confirmation will be fast because lately the fees have been increasing with the ordinal we know.
I think a lot of people have this experience, but I always make adjustments so I don't have to wait long for what's sent to arrive.
The only clear explanation to this is maybe OP actually abandoned the transaction without following through with it or probably is using a wallet that doesn’t support bumping transactions. But even though most of these wallets set the transaction fee to high priority or at least medium which is enough to get it confirmed.
for subsequent transactions, it's a good idea to increase your sat/vb to just above 50+, but still don't expect your transaction to be processed quickly, just be patient.
Even a transaction with fee around 20sat/vbyte will get confirmed within 24hours. I did a transaction today with 16sat/vbyte and it got confirmed although it took almost 10 hours. Most of these low fees are experienced in the night. So if OP transactions has been in the mempool for over two weeks now then the transaction might have be way lower than 10sat/vbyte