Categories > TinyButStrong general >

increase performance by using block in a form

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: olivier
Date: 2005-01-25
Time: 16:52

increase performance by using block in a form

Hello,

After a big test, a form with 100 items (text, textarea, select, checkboxe) with a select from a database.

1st method : all datas from the SELECT are globals PHP vars
TBS syntax : var.field_name
average result -> 17 seconds
(16 second for PHP and TBS and 1 second to send the doc to the browser)

2nd method : all datas from the SELECT are send via an array to the TBS block
TBS syntax : block.field_name
average result -> 2 seconds
(1 second for PHP and TBS and 1 second to send the doc to the browser)

In the two case, the SQL query are the same. The tests are made on easyphp 1.7

To conclude, choice the second method, it's increase performance by 16

Olivier
By: Skrol29
Date: 2005-01-26
Time: 09:09

Re: increase performance by using block in a form

Surprising!
What was the TBS version?
Did you have only one record ?
By: olivier
Date: 2005-01-26
Time: 11:47

Re: increase performance by using block in a form

Yes, there is only one row returned (the database contain 100 000 rows)

Olivier