You need to read up on indexes and how you can use indexes to increase
your speed. Also check on making stored procedures in that these items will
increase your speed also.

Faster hardware will always help, but if your design of the database and
inappropriate indexes will do wonders to making your queries faster.
I have taken queries that take up to 15 or twenty minutes to run and got
them
down to 5 seconds to execute and retrieve all of the data requested just by
changing the an index.

Jack


martinknappe wrote:

> hello
>
> i'm currently reworking a terminology database application for my
> college degree which - if i get it all well done - is going to be used
> *in real life* by my professor and I'm currently having a speed issue:
> he is probably going to complain about query execution time given the
> fact that
> 1st) i did some serious database restructuring (the original database
> had only one table)
> 2nd) i am using firebird as a potentially remote host as opposed to a
> local bde+paradox database
>
> i generated a random database with some 300000 entries in the main
> table and had to find that normal queries (like select * from table
> where value = 'abc') take a couple seconds and that the more complex
> ones can take like five minutes to execute as opposed to the current
> version of the application where everything happens within a fraction
> of a second..now i was wondering how much faster a serious database
> server machine would do; if i told him the problem could be fixed with
> an investment of a couple grand in a state-of-the-art backend server
> with fast hd's and stuff that sure wouldn't be a problem as it would
> have a business purpose but i sure wouldn't want to recommend him to
> waste his money on a high speed machine that instead of a
> 5-minutes-query-execution time has one of 3,5 minutes..how many times
> faster can a serious server be in comparation to my off-the-shelf 500
> quid desktop pc?
>
> thanx,
>
> martin
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
>
> SPONSORED LINKS
> Technical support
> <http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw>
> Computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA>
> Compaq computer technical support
> <http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjEqA6g>
>
> Compaq technical support
> <http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w>
> Hewlett packard technical support
> <http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfmvLcA>
> Microsoft technical support
> <http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
>
>
>
> ------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>