Cross Reference Question (OpenInsight Specific)
At 26 OCT 1998 07:18:41AM Jeff Word wrote:
Is the record, that a cross reference stores its index into, limited by the 64k barrier? Or does it expand beyond one physical record to handle large cross references? If is it limited to 64k then what does OI do when it reaches the limit?
At 26 OCT 1998 12:22PM Andrew P McAuley wrote:
All rows are limited to 64K but XREF indexes will expand to multiple rows thus eliminating the 64K problem.
If however you are using Rev G terminology and actually mean Relational index then you're 64K and the program will fall over with the appropriate FS error.
World Leaders in all things RevSoft
At 26 OCT 1998 12:29PM Jeff Word wrote:
Sorry I did slip back into RevG land for a moment. I did mean Relational indexes in OI. So you are saying that relational indexes do have the 64K limit. Right? Is there any workarounds that would let it expand? We have some relational indexes that we are just not sure how big a customer might get and will they blow up somewhere down the road. Any suggestions?
At 01 NOV 1998 01:51PM Aaron Kaplan wrote:
No real easy workaround. The index values are stored in a field in the record. The record itself is limited to 64K. You could create a relational relation by having another record with a key source*dest. As this record fills towards 64K you could increase to source*dest*n o something like that. It would require another MFS since SI will not handle anything like this. Don't know if anyone else has written something like this, though I'm sure someone has, over the years.
Andrew and I did have a feeling you were slipping into RevG terms.
At 02 NOV 1998 02:13AM [email protected] onmouseover=window.status=why not click here to send me email?;return(true)" - [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Ltd[/url] wrote:
Actually we wrote one for a client over here a while back - called writeWithSplit but unfortunately we don't have the rights so cannot sell one. Would have te redevelop…
World Leaders in all things RevSoft
At 02 NOV 1998 10:09AM Oystein Reigem wrote:
Jeff,
I'm developing a new app, and until recently I thought I needed a relational index. And that index would certainly hit the 64K barrier very soon, so I searched for alternatives. Egbert Poell at Mecomp Automatisering , Holland, kindly offered me the source for an Arev MFS. That MFS also handled relations between an *arbitry* number of tables, which seemed to suit my app well.
I never got as far as getting that programming to work for my purposes. I felt I had to learn the basics of writing an MFS first. Which I did, but then I discussed the matter with Andrew McAuley and Carl Pates. Looking at my case they thought I should ditch the indexing altogether, and rather use queries to get the necessary information when I needed it. With the faster computers of today the need for relational indexing (OI's or your own) isn't as great as at it was before. (I will look into the matter a second time before I make a final decision, though.)
So here are two possible alternatives for you. If you want to contact Egbert Poell I may save you both some time and forward the stuff he sent me (source and some explanations).
- Oystein -