dataTable inefficiencies - hit db twice on each request

[Yee CN]

Hi,   I noticed that if preserveDataModel=false, then JSF will attempt to fetch the table data twice – once during the apply request values phase, and once during the render response phase. It doesn’t do that if preserveDataModel=true, but then I don’t get proper sorting in the table.   Hitting the database twice on every request is not acceptable – so is there a way around this?   Thanks Yee