SQL 10.2
Marc De Roover
omnis1 at arcict.com
Fri Apr 30 22:05:27 UTC 2021
Juan,
If you have to have multiple users on you data, I would recommend to
have a look at setting up a Postgres database (server) instead of
SQLite.
Depending on how “complex” the DML is which you are using, you might
run it to “issues” using the DMLtoSQL.
We are still in the process of reporting “issues” in the DMLtoSQL
solution (our focus lies on Postgres) to the Omnis-team which handles
them swifly.
I have to admit that our code is complex.
Since we are also still in DML ( lots of data files with many many
segments ) we recently have been testing a M1-MacMini and are surprised
by the performance bump this is bringing to Omnis.
We are also in the process of stress-testing the same machine as an ODB
server.
Regards,
Marc
On 30 Apr 2021, at 17:27, Juan Bofill wrote:
> Hi
>
> Having problems with the build in conversion to SQLite. I put the
> code:
>
> Add or uncomment in task $construct at the start
>
> 1) Do $root.$prefs.$scale.$assign(100)
>
> 2) Do $root.$prefs.$alwaysshowmainmenu.$assign(kTrue) ## Not
> available in 4.2? Should keep the menues
>
> visable
>
> 3) Do $root.$prefs.$oldlistsearching.$assign(kTrue) ## search list
> correctly when highlighted
>
> 4) Do $root.$devices.Screen.$visible.$assign(kTrue)Do
> $root.$prefs.$mapdmltodam. $assign("SQLITEDAM")
>
> In the $construct of the STARTUP task. Is that correct?
>
> Thanks!
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
More information about the omnisdev-en
mailing list