The Smallworld Database is the most powerful geographic database technology available on the market today. It supports databases in the 10s of terabytes in size. Far outperforming the competition.
Need to know sizes of tables or alternatives? Check out these tips.
How are things stored in the database?
Run away process updating database?
Have you ever had a rogue process updating the database and you can't figure out what it is? The following code will rollback the alternative and make it readonly. This will stop the updates and hopefully will give you a traceback to let you know what was going on. Note the sleep timing may need adjusting to ensure the switch is done before the rogue process updates the alternative.
Who's Writing to the Alternative
Have you ever tried to go to an alternative and make it writable, but the system says someone else is writing to it? Why not tell me??? You can use "current-writers" on the view to determine who has the alternative writable.
What is Going On with the Database?
If you think you have database performance issue, you can trace what is happening to the database. Use the following… *Joe Burt