Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Axel Granholm — — source: Informix-list mailing list archive (1991-1998)
We have a 4GL application that has been growing in size over the last 6 years, and have a
question about fragmentation aware SQL from within the application.
Many SQL statements in the 4GL application make reference to program variables in
order to return data from the database. Not very unique. Our problem is that this
application does not prepare many of these statements, and therefore fragmentation
elimination does not occur. That is because the SQL is optimized at the prepare state,
and then the Dynamic SQL is opened with a USING clause. Too late for the optimizer to
know how to eliminate fragments.
We could invest time to go back through the application to change the "Important" SQL
that is likely to use fragmentation such that they are PREPARED statements. (Ouch)
Does Informix have any plans to keep the 4GL tool current with the features of the
database? Or, should I change my future development strategy to ALWAYS prepare my
SQL?
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.