Any in-house corporate developers?

[Bob Sneidar]

Livecode is impressively fast. Also, there are tricks to speed it up. For example, Graphic Rendering is by far the greatest choke point for performance, despite the fact that the rendering engine has been greatly enhanced recently to make animations much more robust. But if you are not doing animations, then one trick is to lock the screen before doing anything like showing or hiding objects, going from card to card, opening other stacks, etc. Once the engine enters an idle state, the screen automatically unlocks and renders and there you are! 

Now if by business app you are talking about something that takes a ton of statistical data and then renders it in a 3D space, well I have no experience in that. I am sure there are applications that are very processor intensive which might tax LC more than something custom made in one of the common languages like C++ or Java. I don't know if anyone has done any benchmarking for processor intensive or data intensive apps. 

If accessing a multiuser database is what you have in mind, I was accessing data from a local mySQL server for awhile and it was quite fast. I am not sure how LC apps would measure up to other software when accessing large data sets. My strong opinion is that if someone querying for large data sets, then they probably need to rethink their methods. 

One caveat with native LC database handlers is that the data is returned as a read only cursor. It's up to the end user to populate his forms and tables from that cursor, and then build his queries to update the database as necessary. 

That is where sqlYoga becomes really handy. There are options of returning the data as LC cursors, text, arrays, or a special kind of array called a record object. Record objects are nice in that they can be updated with new column values using sqlYoga commands and functions, and then passed to a command that will update the database based upon the records in the record object. Very nifty. They are essentially writable cursors on steroids. 

I'm fairly good at it, although not completely versed, but Trevor Devore has been excellent in supporting the product. I get a response back within a day, and typically within a few hours. 

I will see about a quick demo video of my framework tomorrow sometime. 

Bob



On Feb 8, 2012, at 5:33 PM, Michael Chean wrote:

> Bob:
> Thanks for the answer.  This is exactly the information that I'm looking
> for, so if you wouldn't mind sharing, I would be interested.  The business
> framework sounds like a sell able product.   I will look into the SQLYoga
> too, it looks very interesting.  Are you concerned at all about the size of
> the application, and how perform-ant it might be?  I can see LiveCode being
> very usable as a business utility, like it says on the site, but for a
> whole business app, I still have questions.
> 
> Mike
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode