mherger wrote: > > I think this falls into the FYI category. > > Interesting indeed. > > > Deleting the database records took over an hour. Adding them again > took > > 17 seconds (which included another 237 new files). Looks like the > delete > > processing is much slower than the inserts or updates. > > I never looked into the performance of deletions. Maybe nobody ever did, > as this usually is a rare case. But I will do so if I find some time.
A missing index springs to mind Main: Receiver (Audiocom) -> Beresford Caiman+ (Gatorized) -> Carver A-500x -> B&W 704 Office: Receiver -> Luxman L-210 -> Stax SR84 Pro -> Beresford Bushmaster -> Superlux HD668B Server: A8-5500, 4 GB, SSD+ 2*1 TB, Win8 w. SBS 7.9.0 (SQLite w. High Mem) Tied together by D-Link DIR-655 + DGS-1008D ------------------------------------------------------------------------ slate's Profile: http://forums.slimdevices.com/member.php?userid=30502 View this thread: http://forums.slimdevices.com/showthread.php?t=101516 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
