Re: Power Objects V2.0

Hello Rick!

I'm an old C-programmer. In C I allways was concerned about speed. So I tried to write speedy code. When I walked over to OPO and basic programming I know I had to sacrifice speed. But as in all programming environment it is possible to write slow code and fast code and there is allways a solution to make code work faster.

I have only worked with Oracle for about a year now and I have learned a lot and have still more to learn. This is my experience with OPO and Oracle.

If you are using a repeater control and a sqllookup for a field, be aware to that OPO have to make a sqllookup for every row in the repeater control. If you for exampel use 3 sqllookups to get values in a repeater control with 100 rows, OPO needs to make 100 x 3 = 300 sqllookups on every refresh of the repeater control. This is slooooow. I have solved this by avoiding sqllookups in repeater controls and if I really need a sqllooked value I have included it in the base table. Another solution is to use a view, that will work under some circumstances.

Derived values seems to work fairly fast.To help things upp a little I have included a total column in the base table so I dont have to recalcutalte every detail when showing the basetable.

Here is other things I have done to make OPO work faster.

I use ECEX SQL to do fast database maipulations and to write PL/SQL blocks.

I also use Database Triggers. This unloads processing from OPO.

All together it gives an application that performs fairly well for a basic program.

I don't think the number of tables have to do so much with speed since this is handled by the database egnine and is only requested when the form is loaded. A complicated form takes longer time to load. My most complicated form is the Order form on the trading system. It consists of five embedded forms (using the tab-control to show them) that are linked to the first form. It is based on a big Order table with > 100 coumns. The form have about 90 columns that need to be filled with data. 15 controls is dropdown lists or listboxes that querys their values from the server. One embedded forms also have 3 repeater controls. The loading time is about 6-10 seconds and flipping thrue records takes about 1 second.

I am using a Pentium 90, and the OPO program is installed localy (it must be). My test evnironment is a NT-server running Oracle Workgroup Server 7.2, and SQL-net 2.2, Named Pipes.

Tomas

Rick Morley <rick.morley_at_morley-data.com> wrote in article <01bbf375$3a275500$1b9d03d0_at_rmorley.cyberenet.net>...
> Happy Holidays To One And All-
>
> Hi Tomas-
> So your the guy with the other copy OPO! :))
>
Received on Sat Dec 28 1996 - 00:00:00 CET