Hi,
While I am a newbie to elixir, I have managed to create a database
application using elixir (thanks for making it so easy to develop the
application). However I have 2 questions on issues that are too
advanced for me.
Question 1.
I will use the movie database to discuss my need. Actor and Movie has
a many-to-many relationship. I would like to rank the movies against
each actor. Suppose I have the following records:
A1 : M1 M2 M3 M4 M5
A2 : M2 M5 M6 M7
and I want to rank them as
A1 : M4 M1 M2 M5 M3
A2 : M2 M6 M5 M7
How can I do this with elixir?
Question 2:
What must I do to ensure that the application is optimized for
queries? Do I need to create some kind of index file if the
application will be making queries against one field? The application
makes queries against different fields at different times.
Many thanks in advance. With best regards, Lila Boc.
--
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en.
