| Jason Boardman 2005-12-13, 8:24 pm |
| Just to throw this out there - here's how I fixed the previously stated
problem (in my first post: "help: dbisqlc hangs when deleting large # of
rows") for anyone who wants to file it away:
The problem: (using v 9.0.2.3169 / linux) when trying to delete large
numbers of rows in dbisqlc, it and the server would hang and i would
have to kill the process on both and restart. i unloaded and rebuilt
the database and still had the same problem.
How I fixed it: i unloaded the db, and hand-edited the reload.sql
command file and removed the entire "Reload Statistics" portion from it
before reloading. The db rebuilt fine and subsequently performed
perfectly when deleting any number of rows in any fashion i chose.
I don't know why this worked or even what the "Reload Statistics"
portion is for (it looks like maybe how to handle changes in page size
from unload to rebuild? but i dunno) but it did work for me in this
case. Perhaps a sybase-master can read this and post reasons why this
might have worked or what it may mean?
Jason Boardman
|