What Recordset type / cursor is needed

Hi i have a page that pulls information from a database it has around 80
records each day its run, the problem is that the view it uses is built
fdrom many smaller views which use a lot of outer joins, so the search takes
approx 30 secs a go. I have coded the ability to sort on column headings
and dont want the user to have to return to the server to get the resultset
re-ordered.

I populate my recordset with

set rs = conn.execute(strSQL)

If i use a different cursor than the firehose will i be able to sort the
results without having to return to the server everytime?

If anyone has any pointers or pages please let me know

thanks in advance

Re: What Recordset type / cursor is needed

Steven Scaife wrote:
> Hi i have a page that pulls information from a database it has around
> 80 records each day its run, the problem is that the view it uses is
> built fdrom many smaller views which use a lot of outer joins, so the
> search takes approx 30 secs a go. I have coded the ability to sort
> on column headings and dont want the user to have to return to the
> server to get the resultset re-ordered.
>
> I populate my recordset with
>
> set rs = conn.execute(strSQL)
>
> If i use a different cursor than the firehose will i be able to sort
> the results without having to return to the server everytime?
>
> If anyone has any pointers or pages please let me know
>
> thanks in advance

By "server", do you mean "web server" or "database server"?

If you are trying to avoid a trip to the "web server" then you are talking
about using client-side scripting to sort the data in response to user
actions, something which is outside of the scope of thi newsgroup (try
..scripting.jscript). this can be most efficiently done using xslt, but there
is a learning curve involved.

If you are trying to avoid another trip to the "database server" then you
need a way to persist the data between requests. if you use a disconnected
recordset, you can use its Save method to save it to a file on the web
server. This file can be reloaded on a subsequent request and resorted using
its Sort property.

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Re: What Recordset type / cursor is needed

Steven Scaife wrote:
> Hi i have a page that pulls information from a database it has around
> 80 records each day its run, the problem is that the view it uses is
> built fdrom many smaller views which use a lot of outer joins, so the
> search takes approx 30 secs a go. I have coded the ability to sort
> on column headings and dont want the user to have to return to the
> server to get the resultset re-ordered.
>
> I populate my recordset with
>
> set rs = conn.execute(strSQL)
>
> If i use a different cursor than the firehose will i be able to sort
> the results without having to return to the server everytime?
>
> If anyone has any pointers or pages please let me know
>
> thanks in advance

Here are a couple of techniques which you would use to get your data to the
client:
http://www.davidpenton.com/testsite/tips/

Once it is at the client, you can use client-side code to manipulate it.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.