EDS
- Posted by Nick Johnson <arachnid at MAD.SCIENTIST.COM> Mar 11, 2000
- 578 views
------=_NextPart_000_0005_01BF8B38.EEBF3100 charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable A few more suggestions: A compression tool would be great - it could rearrange all the records = so there are no free blocks and everything is contiguous. A sort of a = defrag for a database. This would be ideal for when (if) you end up with = a large collection of tiny blocks of free space that were partially = filled by another item, but nothing else will be small enough. Any ideas why the delete takes so long? Twice as long as insert on my = computer. Does it wipe over all the unused space? Nick ------=_NextPart_000_0005_01BF8B38.EEBF3100 charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>A few more suggestions:</FONT></DIV> <DIV><FONT face=3DArial size=3D2>A compression tool would be great - it = could=20 rearrange all the records so there are no free blocks and everything is=20 contiguous. A sort of a defrag for a database. This would be ideal for = when (if)=20 you end up with a large collection of tiny blocks of free space that = were=20 partially filled by another item, but nothing else will be small=20 enough.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Any ideas why the delete takes so long? = Twice as=20 long as insert on my computer. Does it wipe over all the unused=20 space?</FONT></DIV> <DIV> </DIV> ------=_NextPart_000_0005_01BF8B38.EEBF3100--