🚀 go-pugleaf

Oliver wrote:
> Hi
> 
> i have in one special project a HSQL database which in principle 
> works fine, but my user complained that it gets slow once it has 
> only 100 or more entries. Heres the getValueAt method which might
> have a performance problem.

Well, I guess first, what is the question..?

Second, I can not find the code you posted in the DX or dbswing source.. 
So.. Where did you get this code..??


John..


> 
> @SuppressWarnings
> ({"ReturnOfNull", "LoopStatementThatDoesntLoop"})
> public Object getValueAt(int rowIndex, int columnIndex) {
>         Statement stat = null; 
>         try {  stat = MyDBConn.createStatement(); }
>         catch (SQLException e) {  return null;  }
>         String Order = getOrder(SetAscending);  
>         String sqlCmd = "SELECT * FROM Res"+Order;  
>         if (SetFiltered) sqlCmd = "SELECT * FROM Res WHERE "+sqlCmdFiltered+Order;
>         ResultSet rs = null;
>         try {  rs = stat.executeQuery(sqlCmd);}
>         catch (SQLException e) { return null; }
>         try {  while (rs.next())
>                {  rs.absolute(rowIndex + 1);
>                   if (columnIndex==0) return SpecialFormat(rs.getObject(1));
>                   return NumberFormat(rs.getObject(columnIndex + 1));
>                }
>         } catch (SQLException e) { return null; }
>         return "";
> }
> 
> regards
> 
> Oliver


-- 
=============================================
TeamB are volunteer helpers.  Please DO NOT REPLY VIA EMAIL!
Post all questions and replies to this newsgroup ONLY
For papers on DataExpress, Applets, JSP, and Web Development go to:
http://www.microps.com/mps/paperFAQ.html
====================================================