--- In IBObjects@egroups.com, SLSolutions@a... wrote:
Hello
> As a new Interbase/IBO user
I also am a new convert from Paradox to IB
> In this module, every time a new record is added, 3 support tables
> are updated. Two of the support tables have 12 records each added
> and the final support table gets 1 record added for a total of 25
> records added each time a record is added to the main table.
I have found that I get the greatest improvement in performance IF I
convert these types of tasks to Stored Procedures on the Database. I
have used other C/S databases and I know that they create a QEP
(Query Execution Plan) depending upon how the DB interprets the
tuples contained in it. (I assume this is also true of IB) You may
also want to eliminate alot of your master/detail relationships on
the client and create views on the DB to improve performance.
Another tip for improving performance when combining tables is rather
than having a statement like:
select a.fieldname1, b.fieldname1 from tablea a, tableb b where a.fn2
= b.fn2
try
select a.fieldname1 from tablea inner join tableb on tablea.fn2 =
tableb.fn2
This lets the DB know that not all of the records from the first
table will need to be examined and the speed will be faster. You
should do your joins as to iliminate as many records as possible as
fast as possible. That is to say, if you have three tables you are
joining and tables one join two result in 1000 records and tables two
join three result in 500 records and tables one join three result in
5 records, do the one join three then join two.
The last thing to check is the page size of your DB. If you have
allocated large page size but each of your rows are much smaller,
performance will suffer.
(If others have covered this info I apologize for the rehash)
> I made the initial post to the IBObjects group since the group
states
> it is a place for both novice and experienced Interbase/IBO users.
I
> have found that this group is probably not the best place for the
> novice user.
I have not been monitoring this list long, but it seems that it is
very willing to provide help. IMHO.