Am 24.09.2013 um 12:25 schrieb José María Terry Jiménez <[email protected]>:

> Hello  
> 
> I'm starting to work with a web application using SQL Plugin to connect to an 
> Oracle database.

> SQLQuery.setCommandText("SELECT field1,field2,field3 FROM TABLE where 
> field1='t047011' and field2='m3' order by field1,field3")   
> SQLQuery.Execute
> 
> MsgBox("Query executed")
> 

you don't test the timing in a web app with msgboxes?

That's doesn't work as message boxes will show after the work is done.

please do like this:

dim t1 as double = microseconds
// prepare
dim t2 as double = microseconds
// select
dim t3 as double = microseconds
// fill listbox
dim t4 as double = microseconds

and than display the 4 times somewhere, so you can see the differences.

Greetings
Christian

-- 
Read our blog about news on our plugins:

http://www.mbsplugins.de/

_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
[email protected]
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info

Reply via email to