Tim

><< Way back, with DBISAM, I had a similar problem with my email / newsreader app. I eventually found that if I set all the memo fields to null before deleting the whole process ran faster than just deleting. It had something to do with the way freed up blocks were being returned to the pool. Tim did fix it but its one of the things I still try if a delete is taking to long. >>
>
>EDB literally doesn't even touch the BLOBs during deletions. It's literally about as fast as one could expect - per row, it updates the indexes, changes the row update counter, sets a flag on the row, and then it's done.

I think the kicker here (for me) is full text indices which can take a bit of time to process for nice big fat CLOBS, with custom full text indexing. Even with that more main motivator for me in making the mover to ElevateDB was the massive speed improvement in FTI.

Roy Lambert