Clearing OpenInsight SYSLISTS Table

The SYSLISTS table in OpenInsight can become cluttered with old records and much like a TEMP directory it can and should be cleared out. When it comes time to clear the table the clear_table command won't work because SYSLISTS is a protected system table. Instead the easiest thing is to simply select and delete all the records. 

Here is a sample routine to do the task.

Person Info Test Data Table for OpenInsight

Benchmarking with real data or copies of real data is useful but it becomes problematic if you want to compare the performance of one site with another site and can't use the same data set at both sites. Having a consistent data set that is sanitized and can be used at any site can be a useful for performance benchmarks and consistent testing.

Below is a download link for a LinearHash table and accompanying source data table of a 1 million row person information table. Records are sequentially keyed from 1 to 1,000,000.


OpenInsight Dedicated Indexer Health

OpenInsight supports updating indexes directly on the server by running the index update process through the Windows Task Scheduler. If you use that process it has probably silently failed at some point leaving you without indicators until customers call with problems. The article walks through setting up notifications for failed indexes.

Writing to the Event Log From OpenInsight

This article contains a sample BASIC+ routine for use in OI (OpenInsight) that a developer can use to log information to the Windows Event Log on the system running OpenInsight. Writing to the event log is useful for web applications that need to log server exceptions that a system administrator can review later but it's also useful for desktop applications that need to do the same thing without bothering the user.


About Us

Congruity Service is a technology solutions company bringing the best technology solutions to OpenInsight projects, Drupal sites, servers, networks, and your technology needs.