Can't believe it

[Ben Butler]

He is using sqllite.

Ben

On Mon, 10 Aug 2020, 23:50 Juan Bofill, <juanbofillaba at gmail.com> wrote:

> May I ask what SQL ?
>
> > On Aug 10, 2020, at 6:28 PM, Das Goravani <goravanis at gmail.com> wrote:
> >
> >
> > I know this is small hat to some of you guys, but what I’m doing right
> now with Omnis has me thrilled.
> >
> > I am importing 1.7 million cities into my database. It’s a database of
> lookup data that I purchased, all the cities and towns of the world.
> >
> > I am thrilled because Omnis just imported all 1.7 million records into a
> list, and is now saving that data one record at a time, but it does 1000 in
> a matter of seconds.. and there is a small amount of calculation going on
> for each one..
> >
> > I’m typing over the top of that work, in a different program, and there
> is no slow down on the keystrokes whatsoever.. MacBookPro handling it so
> easily.
> >
> > I’m thrilled that I’m working in SQL, with a SQL database, importing ALL
> the cities of the world, doing it FAST and without any problems.
> >
> > In a way I can’t believe it can handle 1.7 million records in a list..
> there are about 20 fields or columns.. I can’t believe it.. but on the
> other hand I rather demand it.. I mean I have 32 GB of memory.. Omnis is a
> power program, aimed at big business.. it SHOULD be able to handle big
> data.. the computer has the space free.. Omnis SHOULD be able to work with
> EXTRA MEMORY in the machine.. I would expect it to.. this file on disk with
> all the cities in it is only 250 MB as a text file.. even if it turns into
> 500 MB inside Omnis I still rather demand that it be able to handle such
> sizes readily.. it ought to be like a work horse that can handle anything..
> it ought to page it out to disk if it has to.. we should be able to work
> with ANYTHING that exists.. because 8 billion people is still a handleable
> number by power horse work horse programs.. SQL can handle it.. so should
> Omnis..
> >
> > And I’m proud to be working with a program aimed as it is at big
> business.. I’m proud to be working with all the cities of the world, proud
> to be working with nearly 2 million records no problem.. happy to be doing
> what I’m doing.. glad that it all works out
> >
> > Now hopefully my ability to update data will come back.. hopefully the
> engineers can figure out what’s wrong.. hopefully there’s a fix besides re
> keying my entire library for example.. it does seem like my library is
> corrupt… nobody else can figure out what’s wrong with my ability to
> update.. everything has been flushed out.. there’s nothing left to suspect
> or examine.. it’s truly a mystery.. and that has me scared.. scared that I
> will be left with it hanging.. thank god it updates if you spell it out in
> an execdirect.. at least I’m left with one avenue even if it does mean
> having 80 else if’s with exec directs underneath them..  Instead of being
> quiet and just putting up with that I’m running it up the flag pole because
> it ought to be different from that.. I ought to be able to $update like
> everybody else..
> >
> > I made a fresh library, fresh database, fresh Omnis.. I’m on a new Mac..
> I have little running.. I reboot.. I’ve run this by everybody and everyone
> has commented.. given me code.. it all checks out.. tried every approach..
> there is NOTHING left to suspect and that has me scared.. what will be the
> ANSWER?  At this point, WHAT could it BE?
> >
> > I highly doubt it’s a bug in Omnis.. because everybody is updating..
> only I am not. What is unique to me that nobody else has?  MY LIBRARY.  My
> library has come up from Omnis 7 or even 5 to the present.. it is 27 years
> old.. it has come up through all the updates to Omnis over all those
> years.. it has code in it that old.. it is 20 MB, many hundreds of
> classes.. impossible to rekey it.. may be possible to recreate it with
> notation writing a copy out one line at a time.. would go fast but writing
> it would be hard, would run fast that is.. Omnis rips through itself no
> problem. I could see code which takes code down one line at a time and
> writes it to a new class of the same type, named one letter different..
> name them all back once the originals are deleted.. fresh library.. unless
> the corruption is hidden in lines of code.. and comes across when you copy
> a line to another place.. if it lives in that and travels in that then
> there’s no hope.. and I dont even know if I’m right but WHAT IS LEFT TO
> SUSPECT?
> >
> > All tables, will insert, but won’t $update, or do it with execdirect and
> variables.. only if you spell it out.. it’s as if my parser is on strike..
> it’s as if the parser has a hard time with my tables.. all of them.. big
> and small..
> >
> > You know Omnis doesn’t let you make mistakes.. it keeps the library in
> good working order by default.. you are forced to type correct variable
> names for the most part.. you are aided in spelling and syntax in all
> respects.. you are given very little freedom to make mistakes.. you can do
> goofy combinations of lines of code if you dont get how Omnis works, if
> you’’re new and haven’t copied and understood good coding habits yet..
> sure.. but not if you follow tried and true pathways of coding in Omnis..
> >
> > Well I can’t believe it but it finished importing the cities.. only took
> about a half hour.. 1.7 million records.. incredible.
> >
> >
> > _____________________________________________________________
> > Manage your list subscriptions at http://lists.omnis-dev.com
> > Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>