I am designing a database using GT.M. I have two options for database data structure. One is to use use one global to store data in all database and use different first subscript for different database. The other is to use different global to store data for different database. Can someone tell me which one use more spaces and which one is has better performance? Also are there some document discussing performance for different design and programming in GTM?
Thanks in advance.
If you have a choice, use different globals. There is not a document that discusses the trade-offs, but in general, more globals should give you better performance as long as you are not forced to use indirection or Xecute with multiple globals. If that is the case, a single global will be better.
With separate globals, you can get at least possibility to split entire database into several database files. This is good because you can get following benefits just by changing global name mapping in your Global Directory:
So from my experience, I can confirm what Bhaskar said in his previous post: if you choose to go with separate globals, you can do all of this tuning relatively independently on your application code itself.
That is helpful. I think I will take the suggestion to use separate global for different database. Thanks a lot.
Log in to post a comment.