This is another of my ‘reminder to self’ blog postings but something that one or two of you might find useful.
In OpenInsight 10 you can view the Database Manager panel and simply select a data table, right mouse click to open the context menu and from there you can do a whole host of things, including rebuilding the index for that table (see the image to the left).
That is great, but what if you want to rebuild all of your indexes. It’s going to be a little cumbersome and time consuming selecting each table, then right mouse clicking, then selecting rebuild index, then waiting for it to rebuild and then repeat, repeat, repeat …
Following a quick conversation with Bob, I had the solution. For the moment, the option to rebuild all indexes in an application from a menu is not available. A convenient menu option might well come in an update, but for now it is as easy as launching the System Monitor (but you’ll have that running already in development mode) and typing ‘update_index””,””,1’ and hitting return to execute the command (as shown below).
You will get a message to let you know how many tables you will be rebuilding the indexes for and a reminder that this “could take a long time”. Click Yes to continue and OpenInsight will go away and index all of your tables. There is no progress bar at the moment, so watch the OpenInsight 10 Main IDE’s status line for messages about the indexing. You’ll see OpenInsight run through your tables and (assuming all goes well, which it will) you will be presented with a “Processing Completed” note in the status line. Job done.
Thank you to Bob Carten for this tip.