Painfully slow performance

[Richard Gaskin]

Peter Haworth wrote:

> I just built my first standalone with LiveCode 4.5 (on OSX) and I'm
> seeing painfully slow performance compared to the same application
> built with 4.0.
>
> I'm using an SQLite database to populate all the data on the cards in
> the app, not sure if there's some problem with the SQLite side of
> things.  Only other thing I can think of is that I am using several
> front scripts.  Opening a card used to be almost instantaneous, now
> it's taking 30-45 seconds.  Bringing up the data for a different
> SQLite row used to be instantaneous, now takes 10 seconds or so.  This
> is consistant across all the cards that handle data fro any table in
> my SQLite database.
>
> The 4.0 standalone still works just fine using the same database.

I haven't spent a lot of time with SQLite in Rev so I can't comment and 
that and look forward to feedback from others on that front.  But FWIW 
in most general areas I find performance in v4.5 to be on par or 
slightly better than in v4.0.

One think I recently discovered is how so many things related to screen 
updates slow to a crawl the moment you use any controls with graphic 
effects.

I've submitted a proposed solution to the RQCC for regaining the lost 
performance:
<http://quality.runrev.com/qacenter/show_bug.cgi?id=9113>

But unless you changed any objects between those two versions so that 
you're now using graphic effects that you hadn't previously used, I'm at 
a loss to explain the speed difference.

I look forward to seeing what this discussion reveals.

--
  Richard Gaskin
  Fourth World
  LiveCode training and consulting: http://www.fourthworld.com
  Webzine for LiveCode developers: http://www.LiveCodeJournal.com
  LiveCode Journal blog: http://LiveCodejournal.com/blog.irv