by BPMargoli » Sat, 01 Apr 2000 04:00:00
> D4,SQL server7.0
> I have a table which has near 1,000,000 recards,when I run a time-consuming
> SQL statement, such as 'select' statement returning a large result dataset
> and with 'group by' and 'order by' clauses, the response time for other
> clients becomes unendurable.
> Thanks for any tip.
> :-):-):-):-):-):-):-):-):-):-):-):-):-)
by Lan » Sun, 02 Apr 2000 04:00:00
D4,SQL server7.0
I have a table which has near 1,000,000 recards,when I run a time-consuming
SQL statement, such as 'select' statement returning a large result dataset
and with 'group by' and 'order by' clauses, the response time for other
clients becomes unendurable.
Thanks for any tip.
:-):-):-):-):-):-):-):-):-):-):-):-):-)
1. SQL*Net tuning - what's reasonable for response times
I have a third party application that needs to connect to the database
over a local area network and run a faily simple query to obtain a
customer balance - all in less then 6 seconds.
Some performance measurements show that 4 seconds is being
consumed by establishing the connection (login). On average the database
has 50 to 70 active connections at any given time with a highwater mark
of 119 connections.
Everything is running on NT 4.0 (workstation and server) and the network
protocol is TCP/IP on 100mb ethernet. The server is a dual pentium with
1GB of memory.
Question: does 4 seconds to login seem reasonable? I've never before
given much though to tuning connect times - my focus has always been on
tuning queries, memory usage, etc.. Frankly, 4 seconds strikes me as not
bad.
I have been unable to track down any information regarding tuning
SQL*Net and would appreciate any recommentations on how I can reduce
this 4 seconds unless the consensus is that 4 seconds is exceptionally
good performance.
2. Are there DBMS vendor independet OLAP modelling tools
3. Time consuming Update SQL statement
4. pgsql-server/doc/src/sgml/ref create_table.sgml
5. Optimizing Cognos Cube build time and response time
6. 16513-NC-Research Triangle Pa-ORACLE-SQL-DBA-Oracle Developer/DBA
7. Response time increase over time
9. Looking for Time Keeping, Time Tracking Software
10. Keep track of execution time per statement in a sproc
11. SQL Select / Great Mystery SQL Response time
12. SQL 2000 Slow Response Time