devxlogo

Store Procedure and View Creation

Store Procedure and View Creation

Question:
We need to create a view based on about 1600 tables. One of the problems is that we cannot enter all of the query into the buffer because the query takes too much space (more than 32k).

Can we create a view by calling some store procedure? If so, can we use the same technique for the insert, update, and delete into that view?

Answer:
That’s insane. Even if you manage to get it to work (assuming that Informix can even handle a view of that size, and I doubt that Informix can join so many tables) your performance will be awful.

You need some serious database redesign if that’s the best way you can figure out how to get the data you need. Talk to your DBA or data architect and figure out another way to do this.

See also  5 Strategies for Supercharging Your CRM
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist