Re: How to make a SQL run longer?

On Jun 27, 1:05 pm, "Luuk" <l...@xxxxxxxxxxx> wrote:
"Raj" <jkama...@xxxxxxxxx> schreef in berichtnews:1182968186.181731.177720@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hell All,
To reproduce one of our cusotmer's probem, I need to make the SQL to
run for more than a minutes before it returns the result set. I do not
have large amount of data in the database to simulate the dealy.

Is there a way in SQL to cause the delay while returning the result
set

Thanks for the help.

Regards
Raj

maybe you should tell us WHY you need a delay, because most in the eyes of
most people a SQL-server must be fast, so no DELAY's....

I hink when you do give that information, there might be another way to
solve your problem.

regards,
Luuk

Our is an reporting application that can connect to either SQL server
or Oracle, retrieve the data and prsent the data over the web for the
end users. This application has the option to preview the data while
developing the report. Duing the preview, if the query takes more
than
one minute than our application hangs.

I need to reproduce this behaviour but unfortunately does not have
enough
data in my database to create the one minute.

Thanks.
Raj


.

Relevant Pages

  • Re: 3vl 2vl and NULL
    ... reporting, MV end-users were either churning out reports and ad hoc ... MV-database-independent applications as often as they do in the SQL ... where I cannot leave MV behind unless I can find a better data model. ... screen to be identical to the logical data model of the database. ...
    (comp.databases.theory)
  • Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database
    ... directly at the SQL 2005 database, ... Document List) must update the database directly with the GMT0 ... I have also done a test with the Reporting Services against the test ... times used by SharePoint itself and the times used in the database. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: MS ACCESS for MAC
    ... SQL is pretty much SQL no matter what application you use. ... relational database - there's really nothing to debate. ... I've had very little to do with FileMaker: In reporting, ...
    (microsoft.public.mac.office)
  • Re: Delphi Roadmap (by David I)
    ... which can be done on the server on the server, ... and this is part of the reason that people buy the reporting ... which would be a bit like saying an SQL ... > parser is a database ...
    (borland.public.delphi.non-technical)
  • Re: Sharepoint Services (V2 and now V3) recording of the date/time recorded into Database
    ... I think I wrote that the other report was of the *database* giving the wrong ... directly at the SQL 2005 database, ... I have also done a test with the Reporting Services against the test ... times used by SharePoint itself and the times used in the database. ...
    (microsoft.public.sharepoint.windowsservices)