Hi, I have panel with several combobox bounded to several datasources. When I set Query on Initialize in Datasource options and run panel which uses this datasource, it runs a little slower. But if I create action with api_datasource.executequery(in_datasourceName_tx => 'mydatasource') for every datasource, put it in postInitialize event of panel and set to off Query on Initialize in Datasource it runs noticeably faster. Why so? I need to speed up opening panel with many comboboxes.


asked 05 Feb '13, 01:50

Emil's gravatar image

accept rate: 0%

edited 05 Feb '13, 01:50

Hi Emil,

Normally, we expect a faster run when Query on Initialize option is set since the api_datasource.executeQuery API causes additional validations to be made.

I prepared a simple example with 7 comboboxes having 2000 rows in each, resulting 1.5 seconds while Query on Initialize option is set and 1.6 seconds when api_datasource.executeQuery API is used. Can you measure elapsed time in each case? (you can use sp_timer package in measuring) If the Query on Initialize option is still slower, can you please prepare a sample application to reproduce your case and send it to contact@theformspider.com?

Thanks in advance,


answered 05 Feb '13, 04:39

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
accept rate: 25%

Thanks. Problem was not in FS. It was DB problem.

(12 Feb '13, 04:32) Emil
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 05 Feb '13, 01:50

Seen: 2,821 times

Last updated: 12 Feb '13, 04:32

© Copyright Gerger 2017