Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Interbase Indeces - Should make things run faster?


This question is not answered. Helpful answers available: 1. Correct answers available: 1.


Permlink Replies: 4 - Last Post: Nov 8, 2016 5:59 AM Last Post By: John MacDonald
John MacDonald

Posts: 179
Registered: 3/22/98
Interbase Indeces - Should make things run faster?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 7, 2016 10:44 AM
I am running a new prototype project in order to review all the functions before we move into production.

We are using FireDac and Interbase server.

In an effort to reduce time of the selects I have added an index through the ibconsole.

I did not seem to get much of a performance boost.

Likely I made a mistake; is there a right way to use the index in my firedac?

--
JMAC out

Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: Interbase Indeces - Should make things run faster?
Helpful
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 7, 2016 2:22 PM   in response to: John MacDonald in response to: John MacDonald
John MacDonald wrote:
I am running a new prototype project in order to review all the functions before we move into production.

We are using FireDac and Interbase server.

In an effort to reduce time of the selects I have added an index through the ibconsole.

I did not seem to get much of a performance boost.

Likely I made a mistake; is there a right way to use the index in my firedac?

--
JMAC out


What is the plan for your SQL? What's the selectivity of that index? FireDAC
itself can not control what indexes will be used since you write the SQL for the
most part.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Interbase Indeces - Should make things run faster?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 7, 2016 3:17 PM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
I'm sorry to say, I'm not sure what "PLAN" means yet.

I saw it in one of the examples I saw online.

My Indeces are pretty simple

Person FNAME and SNAME

The profiler in Interbase indicates that indexed selects are being used.
It looks like we have to leave this to the Interbase.

John

Jeff Overcash (TeamB) wrote:
John MacDonald wrote:
I am running a new prototype project in order to review all the functions before we move into production.

We are using FireDac and Interbase server.

In an effort to reduce time of the selects I have added an index through the ibconsole.

I did not seem to get much of a performance boost.

Likely I made a mistake; is there a right way to use the index in my firedac?

--
JMAC out


What is the plan for your SQL? What's the selectivity of that index? FireDAC
itself can not control what indexes will be used since you write the SQL for the
most part.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

--
JMAC out
Jan Dijkstra

Posts: 206
Registered: 11/4/99
Re: Interbase Indeces - Should make things run faster?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 7, 2016 11:43 PM   in response to: John MacDonald in response to: John MacDonald
John MacDonald wrote:
I'm sorry to say, I'm not sure what "PLAN" means yet.

I saw it in one of the examples I saw online.

My Indeces are pretty simple

Person FNAME and SNAME

The profiler in Interbase indicates that indexed selects are being used.
It looks like we have to leave this to the Interbase.

John

Jeff Overcash (TeamB) wrote:
John MacDonald wrote:
I am running a new prototype project in order to review all the functions before we move into production.

We are using FireDac and Interbase server.

In an effort to reduce time of the selects I have added an index through the ibconsole.

I did not seem to get much of a performance boost.

Likely I made a mistake; is there a right way to use the index in my firedac?

--
JMAC out


What is the plan for your SQL? What's the selectivity of that index? FireDAC
itself can not control what indexes will be used since you write the SQL for the
most part.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

--
JMAC out

I don't know the specifics about InterBase, since I'm using Postgress. The Postgress manual states that, as a standard rule, you should not create indices. Instead, you should let the Postgress query optimizer sort things out for itself. It even contains a warning that creating (too many) indices may have an adverse effect on performance.
John MacDonald

Posts: 179
Registered: 3/22/98
Re: Interbase Indeces - Should make things run faster?  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Nov 8, 2016 5:59 AM   in response to: Jan Dijkstra in response to: Jan Dijkstra
Thanks Jan:

I understand "Too Much", but, it seems to me that we are allowing the server to do the heavy lifting; it would make sense to give it some direction.

I am grateful for your input.

John

Jan Dijkstra wrote:
John MacDonald wrote:
I'm sorry to say, I'm not sure what "PLAN" means yet.

I saw it in one of the examples I saw online.

My Indeces are pretty simple

Person FNAME and SNAME

The profiler in Interbase indicates that indexed selects are being used.
It looks like we have to leave this to the Interbase.

John

Jeff Overcash (TeamB) wrote:
John MacDonald wrote:
I am running a new prototype project in order to review all the functions before we move into production.

We are using FireDac and Interbase server.

In an effort to reduce time of the selects I have added an index through the ibconsole.

I did not seem to get much of a performance boost.

Likely I made a mistake; is there a right way to use the index in my firedac?

--
JMAC out


What is the plan for your SQL? What's the selectivity of that index? FireDAC
itself can not control what indexes will be used since you write the SQL for the
most part.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)

--
JMAC out

I don't know the specifics about InterBase, since I'm using Postgress. The Postgress manual states that, as a standard rule, you should not create indices. Instead, you should let the Postgress query optimizer sort things out for itself. It even contains a warning that creating (too many) indices may have an adverse effect on performance.

--
JMAC out
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02