Re: Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

2017-09-13 Thread John Baughman via 4D_Tech
In my mind a variable is the same thing as a key value pair. The variable name is the key and the data the variable contains is the value. I name all variables with a user readable name so what is the difference between a variable named vFirstName that contains “John” and oObj.firstname that

Re: Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

2017-09-13 Thread Herr Alexander Heintz via 4D_Tech
Hi Bob, i will tell a little story that aligns perfectly with what you told: I have a huge database system for managing car spare parts. each part can be of a specific type, thus having specific descriptive criteria each part can be linked to any number of vehicles, sometimes with a specific

Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

2017-09-13 Thread bob.miller--- via 4D_Tech
Along the lines of, "what is an appropriate use of an object field", I've been considering this: We are a manufacturing company with lots of tools and lots of products. Each tool has various attributes, but each tool type has a different set of characteristics. Silly example that I hope

Re: Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

2017-09-13 Thread David Adams via 4D_Tech
> Here´s my real-world use: > I wrote an iPhone app that collects data (scans barcodes). > That data is in JSON format and transferred via HTTP to a 4D Server. > The server stores that data in an object field (which is never queried. It > just holds the collected data). That's a great example of

Object fields (Was: Re: QUERY BY ATTRIBUTE is slow af)

2017-09-13 Thread Bernd Fröhlich via 4D_Tech
David Adams: > I've been asking about real-world use of object fields for quite some time Here´s my real-world use: I wrote an iPhone app that collects data (scans barcodes). That data is in JSON format and transferred via HTTP to a 4D Server. The server stores that data in an object field