SQL Server slows down

Jawad Malik

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

SQL Server slows down

We are using delphi 3.0 with sql server 6.5. The program we are using
generate lot of data entry. Sometimes the server slows down and for the
user it takes lot of time to post the records. (using stored procedures
to insert the data). This situation occur most of the times when someone
is creating reports using crystal reports. Any thoughts? Please help

Adrian Billingha

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server slows down

I think SQL server will lock all records while the report is in progress

Quote

Jawad Malik wrote in message <34FEB3A3.DC459...@erols.com>...
>We are using delphi 3.0 with sql server 6.5. The program we are using
>generate lot of data entry. Sometimes the server slows down and for the
>user it takes lot of time to post the records. (using stored procedures
>to insert the data). This situation occur most of the times when someone
>is creating reports using crystal reports. Any thoughts? Please help

huynh mar

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:SQL Server slows down

I had the same problem
By adding (nolock) after the name tables like select * from Table(nolock),
you can fix it

Mark

Adrian Billingham a crit:

Quote

> I think SQL server will lock all records while the report is in progress

> Jawad Malik wrote in message <34FEB3A3.DC459...@erols.com>...
> >We are using delphi 3.0 with sql server 6.5. The program we are using
> >generate lot of data entry. Sometimes the server slows down and for the
> >user it takes lot of time to post the records. (using stored procedures
> >to insert the data). This situation occur most of the times when someone
> >is creating reports using crystal reports. Any thoughts? Please help

Other Threads

1. Indy TCP Server slows down when clients connect (Indy Newbie)

2. ADO/SQLServer slowing down in my activex server

3. ADO/SQLServer slowing down in my automation server

4. Interbase server slows down significantly

5. Slow down on Terminal server

6. Slowing down the down key repeat in DBGrid

7. Threaded SQL execution slows down DBGrid?

8. Help MS-SQL transactions slow down

9. slow SQL Links SQL Server 7.0

10. Shutting down a Com server without shutting down the client