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