R: O$ 5.2.3: runtime slow after unicode conversion from O$ 4.3

[Rocco Ventura [Kunvi]]

Hi to all of you.

I've also found this strange behaviour converting from Omnis 4.2
(not-unicode) to 5.1, 8.0.x (unicode).

I've tested with a set of 200 of SELECT SQL-command to a simple Items-table
and I've found that if the statement is written like this:

Begin Statement
Sta: SELECT COD_ART, DESCRIPTION, ETC...
Sta: FROM ITEMS
Sta: WHERE COD_ART=@[RecVAR.COD_ART]
End Statemend
$execdirect() or $prepare()/$execute()

It lastes about 200 seconds

But if it is written like this:

Begin Statement
Sta: SELECT COD_ART, DESCRIPTION, ETC...
Sta: FROM ITEMS
Sta: WHERE COD_ART='[RecVAR.COD_ART]'
End Statemend
$execdirect() or $prepare()/$execute()

It lastes ONLY 1 second for all the 200 SQL-Commands.

In Omnis 4.2 it lastes only 1 second for both the statements-version.

I've also send a request to Omnis Software for this strange behaviour.

Bye

Rocco 
_________________________________
Distinti saluti. Best regards.

Rocco Dr. Ventura
WMS Analist and Software Developer

KUNVI srl - Experiences Holding - www.kunvi.it
Email: r.ventura at kunvi.it

-----Messaggio originale-----
Da: omnisdev-en [mailto:omnisdev-en-bounces at lists.omnis-dev.com] Per conto
di IT
Inviato: venerdì 24 marzo 2017 11:38
A: OmnisDev List - English <omnisdev-en at lists.omnis-dev.com>
Oggetto: Re: O$ 5.2.3: runtime slow after unicode conversion from O$ 4.3

Hi Nick

Did you test setting $prefs.$maxcachedclasses.$assign(xxx) to some greater
value ?

Perhaps Studio5 unicode needs a bigger format cache to be so responsive than
Studio4 non-unicode.

regards

xavier


El 23/03/2017, a las 14:51, Nick Renders <omnis1 at arcict.com> escribió:

> Hi,
> 
> We recently updated our Omnis Studio 4.3.2.1 non-unicode library to 
> Omnis Studio 5.2.3 (unicode). We didn't need to make any changes to 
> the library's code as we had already made all the necessary 
> preparations in Studio 4.
> 
> The library is now run on the same machines as before (most of which 
> are running MacOS 10.8.5), only now they are using the Omnis Studio
> 5.2.3 runtime. We connect to the same ODB and Postgres databases as 
> before.
> 
> But for some reason, the library (or rather the runtime) slows down 
> after some time using it. It feels like there is some memory leak 
> causing it, because when you quit the application and relaunch, 
> everything is back OK.
> 
> Does anybody have a similar experience? Any clue what might be causing 
> this?
> 
> My first thought was: object instances. We use a bunch of them, but 
> had no performance issues in Studio 4. Has anything changed between 
> Studio 4 and 5 on how objects are handled?
> 
> My second thought was: externals. Again, we use a bunch of them, and 
> obviously they are not exactly the same (unicode vs non-unicode).
> But my tests don't show any performance decreases when I only use the 
> externals.
> 
> 
> Best regards,
> 
> Nick Renders
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com


_____________________________________________________________
Manage your list subscriptions at http://lists.omnis-dev.com


---
Questa e-mail è stata controllata per individuare virus con Avast antivirus.
https://www.avast.com/antivirus