Indexing the t_name.name field, I can increase speed, but only if I
restrict my search to something like :
select *
from t_name
where t_name.name like 'my_search%'
(In this case it takes generally less than 1 second)
My question : Are there algorithms or tools that can speed up such a
type o
Hi,
I'am having major performance issues with post gre 7.3.1 db. Kindly suggest all
the possible means by which i can optimize the performance of this database. If not
all, some ideas (even if they are common) are also welcome. There is no optimisation
done to the default configuration of
[EMAIL PROTECTED] ("Kamalraj Singh Madhan") writes:
> Hi, I'am having major performance issues with post gre 7.3.1
> db. Kindly suggest all the possible means by which i can optimize
> the performance of this database. If not all, some ideas (even if
> they are common) are also welcome. There is no
Kamalraj Singh Madhan wrote:
Hi,
I'am having major performance issues with post gre 7.3.1 db. Kindly suggest all the possible means by which i can optimize the performance of this database. If not all, some ideas (even if they are common) are also welcome. There is no optimisation done to th
Hi,
I'am having major performance issues with post gre 7.3.1 db. Kindly suggest all
the possible means by which i can optimize the performance of this database. If not
all, some ideas (even if they are common) are also welcome. There is no optimisation
done to the default configuration of