Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: Informix
Expertise: Beginner
Aug 11, 2000

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.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap