gharris999 wrote: > Django: what would you expect the behavior to be like using the > drop/create wipe method on systems whose DBs are on "slow media"...e.g. > SD cards or such? Would delete * rescans likely end up being faster on > those systems since the file space remains allocated?
Hi, honestly i cant tell you that.... To make shure a sd Card lives long we had to minimize hotspots (places that are often overwritten) in therorie deleting a file as file and write a new file soon afterwards should be worser than a sql statement -[delete * from]- that not deletes the file, but writes some zeros in the places. (A -delete * from-) doesnt resize the db file itself - for a sd card may the "original" way should be better (in meaning sd card should live longer). The times that improved performance after a "defragmentation" of a Diskdrive are long time ago - defrag a SD/SSD is forbidden since they started production. But that (SD/SSD Cards/) was not my intention i just ondering about "why" a clean / wipe /rescan doesnt -drop from- only -delete from-. I Understood Michael - just a poor guy would have eg. a artwork.db with more than 2 GB and a "Disk" formatted in FAT32 (where the 2 gb limit is a problem) may not lives anymore in the wildlife.:D Cheers Gruss Jan ------------------------------------------------------------------------ DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516 View this thread: http://forums.slimdevices.com/showthread.php?t=100444 _______________________________________________ beta mailing list [email protected] http://lists.slimdevices.com/mailman/listinfo/beta
