[Hx] Question about Index

[tim]

1) Stupid questquestionion, can't see it. I am using an index to sort a list - last name firstname are text fields. When i place in an indue last in first slot, first in second, it sorts on the last fine, but first is jumbled. I'd graphic it but has real names.

2) Are we having another video meeting?

Thanks.

Tim
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

You received this message because you are subscribed to the mailing list <Hel...@gibhenry.com>.
To unsubscribe, send an email <Helix...@gibhenry.com>; to switch to DIGEST mode, send an email to <Helix-L...@gibhenry.com>; to contact a human being, send an email to <Helix-L...@gibhenry.com>.
Google archive since 20 August 2006: http://groups.google.com/group/helix-l.
Basic archive since March 2017: https://gibhenry.com:9100/Lists/Helix-L/List.html

[Quipu Pty Ltd]

1. Try forcing an index rebuild

a. from the menu, 

b. reverse index order of any fields.

c. build another index from scratch.

If that fails then you’ve probably got a reason to run the utilities.

2. Yes. Hopefully next month if I can get it sorted with the presenter (any offers?)

Aiming for a discussion on E-R diagrams, keys - candidate, primary, foreign, and concatenated. Best practices

Unless people aren’t interested.

—
Lee Rydstrand
l...@quipu.com.au

041 140 3281

Quipu Pty Ltd

[Gary Cosimini]

Lee, I’d very much appreciate a session on this topic as I am trying to learn how to construct SQL databases in parallel with my Helix collections.

Entity-Relationship diagrams are fascinating in concept, but I’m confused by how to put them into practice.

And MySQL field properties—Unsigned, Zerofill, Binary, Allow Null, Key, Default, Encoding, Collation, etc. etc.—are so strange compared to Helix’s.

Clearing up these concepts would be of great value to me, so I’d be very interested in this topic.

Gary

[Quipu Pty Ltd]

That’s great. I’m encouraged.

Let me add that once we’re all on the same page wrt to the fundamentals of collection architecting (the E-R diagram), I’ve lined Lenny up to do a deep dive into optimisation techniques, specifically with regard to querying. No doubt he’ll push a barrow with dashboards in it but that’s all good too, since effective navigation starts with minimising menu usage.

Next up Matt has offered a session on using AppleScript effectively. If you have any specific requests please detail them here. I, for that one, want to see a script that builds a post with multiple triplets and attaches it to a View.

Following that I’d like to see a session on troubleshooting and diagnostic techniques.

And following that…

Any offers to help or present are welcome, I’m just the scheduler.

—
Lee Rydstrand
l...@quipu.com.au

041 140 3281

Quipu Pty Ltd

[Steve Stoddart]

Lee,

Can’t thank you enough for arranging these video meetings / seminars. I’m 100% interested. Will they be recorded as I’m sure topics will come up that will make my brain fizz and I will want to revisit. 

Thanks,

Steve

On Jun 14, 2021, at 9:51 PM, Quipu Pty Ltd <Hel...@gibhenry.com> wrote:

1. Try forcing an index rebuild

a. from the menu, 

b. reverse index order of any fields.

c. build another index from scratch.

If that fails then you’ve probably got a reason to run the utilities.

2. Yes. Hopefully next month if I can get it sorted with the presenter (any offers?)

Aiming for a discussion on E-R diagrams, keys - candidate, primary, foreign, and concatenated. Best practices

Unless people aren’t interested.

—
Lee Rydstrand
l...@quipu.com.au

041 140 3281

Quipu Pty Ltd