PSPP-BUG: [bug #33260] terrible performance when data paged to disk

[John Darrington]

Update of bug #33260 (project pspp):

                Category:                   Other => Graphical User Interface

    _______________________________________________________

Follow-up Comment #4:

Your test is not representative of typical GUI usage.

For the following experiment I used the dimensions reported by this user:
http://lists.gnu.org/archive/html/pspp-users/2013-02/msg00005.html

and produced the following syntax:

input program.
vector vec(1174).
loop #c = 1 to 27500.
 loop #v = 1 to 1174.
  compute vec(#v) = #v.
 end loop. 
 end case.
end loop.
end file.
end input program.


frequencies /variables  vec1.



The results:

1. Running the entire syntax from the command line: 

   real    0m21.848s
   user    0m18.893s
   sys     0m2.000s

Let us say 20 seconds.  Acceptable.



2. Load the syntax into the gui, thus:  
     psppire file.sps
   Then click Run|All :
   I timed that at 31 seconds.  I think this is also acceptable.


3. a) Load the syntax into the gui, thus:  
     psppire file.sps
   b) Then select lines 1 to 10. (from INPUT PROGRAM thru END INPUT PROGRAM).
   c ) Click Run|Selection - this loads the data into the sheet.
       This also takes 31 seconds.  Acceptable.
   d) Now select the line "frequencies /variables  vec1." and
      Click Run|Selection
      I waited more than 7 minutes for this to complete (then I got fed up
with waiting).  This is NOT acceptable.

These results would agree with what was reported in the bug report above.

So it would seem that there is a very poor performance reading data from the
gui's datasheet. 
   

   

    _______________________________________________________

Reply to this item at:

  <http://savannah.gnu.org/bugs/?33260>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/