Re: ISQL vs. 4GL

Kai Shen wrote: > > Hi, > is there any known performance difference between ISQL and a 4GL > program? > In our special case I want to do a major delete and insert between two > servers connected by INET. > I thought maybe a prepare cursor with 4GL could save me some time > compared to plain SQL. > > TIA, > Kai It sounds to me as if the processing will mainly be moving data around. If so, I would use ISQL. 4GL would be faster only if you had some SQL statements that you wanted to use repeatedly. Then it is worthwhile to prepare them. Preparing basically parses the SQL and prepares a query plan, it does not speed up the actual data movement. You have to allow for the time it takes to write, compile and debug the 4GL. -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/