Should I use Data Shaping

[TimVtoo]

Hello everyone. This pretty much the first time posting in a forum, so please dont shout at me for doing something wrong :).

SQL SERVER 2005
CLASSIC ASP VBSCRIPT
SQL Server And IIS are running on the same machine.

I have been developing an online shopping store for over 12months now and am getting close to completion. However there is still a lot of work to be done by others with regard to data entry, so have some time on my hands.

I have set about tidying up and refining my code and while doing so I thought I would search the net for information on 'Nested Recordsets' as one of the fields in the main products page is in effect a recordset itself and am currently making a seperate data request for each record returned.
( I hope this makes sence?)
See example here
1+£0.00
10+£0.00..etc.


As result, I stumbled across a few articles on Data Shaping which looks fantastic and after a bit of messing, I have managed to get a simple moc up working.

My concern with Data Shaping is this:

The only articles I have found, are quite old.

To get it to work, I had to set up a SQLOLEDB connection as oposed to ADODB. Forgive my ignorance, but isn't OLE an older technology??

I currently always use ADODB Commands & stored procedures that usualy return multiple recordsets.

I should also point out that although the datase is going to have in excess of 30,000 products and a lot of related data on each product, it is set up to only ever return between 5 and 30 product records on a page at any 1 time, and as a result generaly returns a page in under 1 seond. But who knows, if the site is successfull and has lots of hit all the time?

IS DATA SHAPING SOMETHING I SHOULD BE THINKING ABOUT, OR IS IT A STEP BACKWARDS???

Any thoughts or comment would be much apreciated.

[jhardman]

It sounds like the methods you had already used are sufficient, but I'm not sure I've ever heard of "data shaping", so I'll look it up, see what it means.

[jhardman]

Thanks for bringing this up! I looked it up on 4 guys from rolla and it definitely looks like a good idea, I even see how I could use it. The author of the above-linked article says it was introduced in ADO 2.0 which is no older than ASP, do you have any way to test it using a computer without the older Ole installed? This article was written in '99, just about when ASP was hitting its zenith, yes it's old now, but so is ASP. The real test would be trying this in ASP.NET.

Jared

[TimVtoo]

Hi Jared, thanks for your input.
I have now got this in place on my default page and seems to be fine, but to answer my own question. The difference really isn't noticable IN THIS CASE.
However, Im sure it has its place.
I would imagine that if the database and iis where on different machines and the sub recordsets where larger, it could be a huge benifit!

As far as .net goes, thats outa my scope for now... Maybe the next job :)

Tim