Tech Tips
Innovative Information Management            

Technical Tips
Well, its been ages since I started this little page. too busy I guess, but now, I hope to be able to add a little content to this part of the website.

Performance tips

Why is my search so slow

One of the most important aspects of performance is simply how long the user waits for results. This could also be a somewhat complicated topic, and there is certainly no magic-bullet solution. Below I will highlight a few problems that I have come across at a number of sites, and which may help in resolving "intermittent" problems in what are generally well performing systems.

  • EXACT PHRASE - using phrases containing stop words.
  • THE ASTERIX - especially front truncation
  • SORTING
  • USING THE WRONG OPERATOR - INCL with EXACT INDEX / EQUAL with INCLUSIVE INDEX
  • SEARCHING ON FIELD WITH NO INDEX - dmr ignores UNIQUE indexes when INDEX=record.* ! So watch out if you have deleted a file containing indexes, and then use DMR with index=record.*
If you have a well designed database, with generally good performance, then one or more of the issues mentioned above could cause problems, and slow down all users. HTH!

Web Server tips

Improved Security for Webserver Gateway Users

One of the big problems we have had, in using the Basis Webserver Gateway is its simplistic security model. In an attempt to provide a more robust security model that allowed for a complex set of rules about who can see certain documents from within a BASIS Database, the following idea came to mind

  • Use a simple $UID=ACCESS_FIELD restriction in a View Restirction
  • Use a Thesaurus that will map the users UID to one or more GROUPS
  • Let ACCESS_FIELD be a multiple occuring field that will contain one or more UID's or GROUPS that are allowed to access a particular document.
Using a simple view restriction, and a Thesaurus can provide very flexible security. A simple group of ALL, for example, can contain all Users Id's. Smaller Groups for Projects, Or departments could be easily created. Automatic creation of groups from a PeopleSoft Database (for example) is easily done, and can be refreshed nightly so that administrative overhead is kept to a minimum.
. . .
Home
Bio
Contact Info
Services
Consulting
Maintenance
and Support

Training
Products
BASIS
RAD for BASIS
BWX
MySQL
Developer's Corner
Tech Tips
Links
CANBUG
Home Teradocs Systems Inc. © 2001-2005 Top