Subject | Re: Repost: How to improve RDB$RELATION_CONSTRAINTS readings? |
---|---|
Author | mmenaz |
Post date | 2002-02-10T20:18:23Z |
--- In ib-support@y..., Doug Chamberlin <DChamberlin@A...> wrote:
In addition, I prefer save server resources if it's possible with a good design instead of a bad one.
Thanks :)
Marco Menardi
> the fact that it is scanned many times may not be a real performanceI'm just looking at the access count and wondering if, since my test has 20 rows, it will be a problem when I will have 10,000 rows!
> problem. It more likely indicates simply that the data in the table is used
> many times in your stored procedure and trigger logic.
>
> Are you seeing a performance problem that you think points to this table?
> Or, are you just looking at the access count and wondering what the need
> for it is?
In addition, I prefer save server resources if it's possible with a good design instead of a bad one.
Thanks :)
Marco Menardi