Hello all,

My question stems purely from curiousity, and I'd be much obliged if
you'd help, but it's not imperative that I get an answer.  I wrote some
code that runs a whole bunch of queries for me and it works, but I'm
very put off by the extremely long time it takes.  I'm sure there is a
better way to do what I'm doing, so I'm would like someone to redirect
my efforts towards a better way of doing things.  In short, doing 540*2
queries and this obviously takes forever and a day.  Alright, lemme
hear your ideas.

Code Purpose:  Create a file for bulk insertion.

PreparedStatement pstmt = conn.prepareStatement("select IV00108.TOQTY,
IV00108.FROMQTY, IV00108.ITEMNMBR, IV00108.UOMPRICE FROM IV00108 WHERE
PRCLEVEL = 'LEVEL 01' AND ITEMNMBR = ? ORDER BY ITEMNMBR");
PreparedStatement pstmtList = conn.prepareStatement("select
IV00105.LISTPRCE FROM IV00105 WHERE ITEMNMBR = ? AND CURNCYID = 'Z-US$'
ORDER BY ITEMNMBR");
String temp3 = "";
temp3 = bp.readLine();
String[] qtyFROM, qtyTO, uomPRICE, itemNMBR;
String listPrce;
int rSets = 0;
while(temp3 != null){
    pstmt.clearParameters();
    pstmt.setString(1, temp3);
    pstmtList.clearParameters();
    pstmtList.setString(1, temp3);
    ResultSet bpRS = pstmt.executeQuery();
    ResultSet bpRSListPrc = pstmtList.executeQuery();
    qtyFROM = new String[12];
    qtyTO = new String[12];
    itemNMBR = new String[12];
    uomPRICE = new String[12];
int t = 0;
bpRSListPrc.next();
listPrce = bpRSListPrc.getString("LISTPRCE");
rSets++;
System.out.println(rSets);
    while (bpRS.next()){
        qtyFROM[t] = bpRS.getString("FROMQTY");
        qtyTO[t] = bpRS.getString("TOQTY");
        itemNMBR[t] = bpRS.getString("ITEMNMBR");
        uomPRICE[t] = bpRS.getString("UOMPRICE");
        Float uom = Float.valueOf(uomPRICE[t]).floatValue();
        Float list = Float.valueOf(listPrce).floatValue();
        Float adjustedPrice = (uom * .01f) * list;
        adjustedPrice = Math.round(adjustedPrice*100)/100f;
        bulk.println("NET\tI\t" + temp3.trim() + "\tEACH\t" + qtyFROM[t] +
"\t" + qtyTO[t] + "\t" + adjustedPrice + "\t1\t1\t" + 16384 * (t+1));
        t++;
    }
    temp3 = bp.readLine();
    bpRS.close();
    bpRSListPrc.close();
}