Thanks for the idea wysota, i have subclassed QAstrabctTableModel and implement a buffer with the sql results and it works at good speed in my development machine, i will try with more large datasets and older machines when i implement the model in one of my customer machines.