We've written a client using the Texis API. It works great and delivers results fast during normal operation, but the first query is always sluggish as it needs to connect to the DB and (I think) load the index in memory.
Is there anything I can do to maintain all the indexes in memory all the time?
Also, is there a timeout on the connection created by the openserver function?
Could you elaborate a bit more:
what program is managing the indices?
For instance, if I start a new instance of a program every time I need to perform a query, does it reload the indices every time or is there a background program that keeps it in memory for me?
If I have multiple instances of that same program running simultaneously, do they share the same index in memory?
If you're using NCGDIRECT your program is the one accessing the tables and indices. Otherwise texisd is accessing them. Multiple instances of either do not share, though the OS file caching will benefit all processes using the same files. Stopping and starting your app will cause the database to be closed and reopened. Subsequent opens will benefit from OS file cache.
John, just to make things clear: when you say that the 2 instances of the program may share the same copy of the index, you mean the program have to explicitly allow that.
The index is a piece of data for the program, so the OS is never going to share it between instances unless the program made the request explicitly. Is this possible with the Texis API?
WRT the OS caching: it is efficient for small pieces of information but an index can be several hundred of MB. Surely there has to be a better way to keep it in memory and share it between the programs running the queries no?
I have about 4GB of memory on the server and I want to dedicate most of it to the index. Any recommendation?
