Re: 4GL Database Feature Question

In article <691s0i$4g9$1@news2.digex.net>, Axel Granholm <agranholm@smart-com.com> writes >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? > Always prepare, remember most future development will be client/server and from most client tools (on Windows) you pass a String containing the SQL to a driver for the database. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care