> For small records
> it is not much problems. But as the records grew (up to 12,000
> records) the
> difference is quite significant.
Although there are many tuning options, I'd suggest starting by making sure
you have an index (unique in cases where appropriate) on accposd.date
accposd.item, items.name, accposd.loose and items.name. Then do an
"analyze;" on the DB to make sure the database takes advantage of the
indexes where appropriate.
If this doesn't help, there are other options to pursue, but this is where I
would start.
-Nick