Categories > TinyButStrong general >

Slow while merging one query with three bolcks.

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Hassan
Date: 2007-05-10
Time: 06:48

Slow while merging one query with three bolcks.

$TBS->MergeBlock('country,b,m',$obj_con_database->link_id(),'SELECT Code, Name, PhoneCode FROM countries order by 2 ASC') ;

I am using upper query to load  a list of countries in drop down menu, and I m loading this list three drop down menu on a same web page. if I remove this query my page gets loded in 2-3 seconds but with this it takes 10-11 seconds. Don;t think it is because of databse because  i have tested it and its not making any delay. I think it is with the function.

Please any solution.
By: Skrol29
Date: 2007-05-10
Time: 10:14

Re: Slow while merging one query with three bolcks.

Hi,

Your MergeBlock() call has nothing strange. It may come from your block definition. Can you tell us more about it ?
If you have any [var] fields inside it is better to chnage them to [onload] fields.