Hi jano,
There are definitely more expert people here than I, but I can give you some pointers on where to start.
The first thing you want to review is the post on how to evaluate a mattress to know if it’s suitable for you, and understand how to tell if the mattress is made from more durable materials that might last a long time. The post is here and has links to several other important articles.
As to overall advice, this website tends to focus on providing you a means to select what’s right for you and guide you to your own decision. That said, generally speaking, you’re going to get advice to avoid the big box stores and larger brand name mattresses, mostly because they don’t disclose what’s inside the mattress for you to be able to tell if it’s going to be durable or not, and when people disassemble those mattresses they often find that they are made with lower quality/ less durable materials.
Nevertheless, I’d recommend you start at post #1 above as it contains a wealth of information!