Smallworld Database

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.

OS Configurations/Performance

DB Data Techniques

DB Administration

DB Information

Need to know sizes of tables or alternatives? Check out these tips.

DB Performance (thru Magik)

DB Storage

How are things stored in the database?

DB Server & Client Settings

Misc….

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

ds_environment.set_trace(3)
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License