Hello, Nick! Tuesday, July 30, 2013, 1:41:21 PM, you wrote:
NU> gstat -r output: NU> pre backup/restore you again checked select * from table at that moment? and it is 4.8 sec? NU> post backup/restore and here - 0.3 sec? NU> I obviously expect some improvement from backup/restore but 15x seems more NU> than can be accounted for I doubt that your measures are correct. Since I see 130k records, I think that 4.8 seconds of select * from table takes FetchAll, i.e. transferring all records to client application. And, 0.3 seconds for the same query on 130k records means that FetchAll is not in effect, ony some parts of records are being read. Or, (which is a bit suspicious), your hard drive is very slow at random reads, if at first case this table pages were fragmented in the DB. -- Dmitry Kuzmenko, www.ib-aid.com
