I use CDML to develop FileMaker driven websites. What are the advantages or disadvantages of using Lasso vs. CDML? Thanks.

Lets start with wider syntax, I guess more than 800 commands.

Now Lasso has internal MySQL and you can use FM and MySQL in the same solution.

Much better Inlines.

Much better security.

More difficult to program some things for FileMaker.

Unlimited number of variables.

Sessions.

Lasso is really heavy-duty stuff.

Can you say that Lasso adds multi-threading?

vasilek said:

Can you say that Lasso adds multi-threading?

Lasso can not add multi-threading to filemaker pro cause FMP is mono thread for db request.

For script execution yes Lasso is multi-thread.

And you can say that lasso add a database abasction layer to your application

vasilek said:

Can you say that Lasso adds multi-threading?

In a way -- yes.

What is the query?

Incoming request in thread A

Contacting WC in thread A

Waiting for answer in thread A

Receiving data in thread A

Processing data in Lasso Script in thread A

Serving data to visitors from thread A.

In fact during peak hits it will be multithreaded like this:

Incoming request in thread A

Contacting WC in thread A

Incoming request in thread B

Contacting WC in thread B -- MUST WAIT

Waiting for answer in thread A

Receiving data in thread A

Waiting for answer in thread B

Receiving data in thread B

Incoming request in thread C

Processing data in Lasso Script in thread A

Contacting WC in thread C

Processing data in Lasso Script in thread B

Waiting for answer in thread C

Serving data to visitors from thread B

Incoming request in thread D

Receiving data in thread C

Serving data to visitors from thread A

Processing data in Lasso Script in thread C

Serving data to visitors from thread C

Etc

So in Lasso A-B-C-D is processed in parallel, WebCompanion will work in serial fashion.

But WC will be only supplying data to Lasso and all processing, scripts (execution routines), conditionals and conversions are running in multithreaded Lasso engine.

From my latest test:

FM 202,219 records

Found set 178 records

Return time from Lasso -- complete time to build HTML page

The times in seconds:

0.063

0.062

0.047

0.079

0.062

W2000 P4 2.66GHz ATA100 disk.

omiossec said:

For script execution yes Lasso is multi-thread.

Read that as -- For LASSO script execution yes Lasso is multi-thread.

Nothing to do with FM scripts.

Anatoli said:

Read that as -- For LASSO script execution yes Lasso is multi-thread.

Nothing to do with FM scripts.

Yes I forget only Lasso script are multi-thread (as they run on a multi-thread server like apache, IIS, ...) and remember that Lasso is not only a language but an application server

Thank you

I once got a very good idea to let this work very fast.

When the user logs in to the website, do some queries to your filemaker database.

Store these results in arrays in your lassoscript. (internally they are stored in Lasso MySQL)

From then on, within the same session, you can work with the arrays (super fast) and you don't have to wait any longer for the webcompanion.

and 7 will be able to cache/queue requests to slower DB's....