Forum OpenACS Development: Re: Limitation on length of bind variables

Collapse
3: Re: Limitation on length of bind variables (response to 1)
Posted by Janine Ohmer on 02/25/04 03:52 PM
Thanks, Dirk.

Unfortunately getting rid of the long IN lists would require a more substantial rewrite than I'm chartered to do, so I guess Tom Kyte's solution will have to do.  It is fast enough now, I just worry how it will degrade as the lists get even longer.

Collapse
4: Re: Limitation on length of bind variables (response to 3)
Posted by Dirk Gomez on 02/25/04 04:14 PM
Yes, I know. I was going through the portal code trying to track down where the in lists get created (with the idea of putting that into a mapping table) but I gave up after a couple of hours.

I hope that Don's rewrite does away with this.