Should I use Data Shaping - ASP / Active Server Pages

22 New Member

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.

Jul 6 '08 #1

Subscribe Reply

1515

jhardman

3,406

Recognized Expert Specialist

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.

Jul 8 '08 #2

jhardman

3,406

Recognized Expert Specialist

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

Jul 8 '08 #3

TimVtoo

New Member

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

Jul 9 '08 #4

Similar topics

303

17776

BIG successes of Lisp (was ...)

by: mike420 | last post by:

In the context of LATEX, some Pythonista asked what the big successes of Lisp were. I think there were at least three *big* successes. a. orbitz.com web site uses Lisp for algorithms, etc. b. Yahoo store was originally written in Lisp. c. Emacs The issues with these will probably come up, so I might as well mention them myself (which will also make this a more balanced

Python

2436

Prothon should not borrow Python strings!

by: Paul Prescod | last post by:

I skimmed the tutorial and something alarmed me. "Strings are a powerful data type in Prothon. Unlike many languages, they can be of unlimited size (constrained only by memory size) and can hold any arbitrary data, even binary data such as photos and movies.They are of course also good for their traditional role of storing and manipulating text." This view of strings is about a decade out of date with modern programmimg practice. From...

Python

1361

Bandwith Shaping

by: flamesrock | last post by:

Just curious - is there an easy way to shape bandwith in python. If I wanted to have a max download speed for instance -thanks

Python

4112

Where Is It Written That I Should Use CSS Positioning?

by: Jack Hughes | last post by:

This argument has come up two or three times lately. We have a web standards document at our company that say "Use valid HTML 4; We don't recommend switching to DIV-based CSS-P for layout just yet though, tables are a lot easier." That's because we have a lot of developers who aren't ready to move to CSS-P and DIVs just yet. But I'm being told our policies were contradictory. If we're going to

HTML / CSS

1285

Shaping data/multiple result sets - hmmm...

by: Mike Kingscott | last post by:

Hi all, I wonder if anyone can help? I have a need to display some data on my web page (the results of a search) for links. Here's the thing: Each link can belong to one or more category (yes, I have a many-to-many table). When the links are retrieved, I also want to retrieve the categories the link is found in. Let's say link A appears in categories X, Y, and Z, and a keyword search brings back link A - due to the way the query is...

ASP.NET

2327

should I bind datagrid to array or temporary dataset?

by: AFN | last post by:

I need to manually create the data to be shown in a datagrid (or some data table object). Should I create an array and bind the array to the datagrid OR should I create a temporary dataset and bind that to the datagrid? I have never done either (usually I get a recordset from a stored procedure and bind results directly). I also don't know which is faster. Whichever you suggest, can you give a couple lines of sample code? Thank...

ASP.NET

2189

Data Provider

by: Paul Deibel | last post by:

Hello I am working on a VB.Net project where I need to change the data provider from OLEDB to OracleClient. I am also looking to use "shaping" and I am looking for the equivalent to "Provider=MSDataShape.1" when using an OracleClient connection string. The provider syntax works fine with an OLEDB Connection String. Does anyone know how to do this? I am using the 1.1 framework, and Visual Studio vb.net (Note ... I switched to...

Visual Basic .NET

1139

data shapes

by: Support | last post by:

Anyone with experience in data shapes (hierarchical recordsets) with SQL stored procedures ? I use them with ASP but I cannot find reference on how to use them in VB.NET StrShape="SHAPE {{ CALL Sproc_TestTopShapeEmails('"& Var_Guid &"') }} APPEND({{ CALL Sproc_TestBottomShapeEmails(?)}} RELATE intEMAILSunid TO PARAMETER 0) As Thing" Thanks

Visual Basic .NET

1493

Which database should I use?

by: HKSHK | last post by:

Hi guys, I want to write a database application, which I later want to sell. Now I am looking for a nice, little database which would have to fullfil these requirements: * Either free or low cost * Support encryption * run via network or locally * low CPU usage (I don't need a big web server database)

Visual Basic .NET

9643

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9480

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10147

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

7494

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5379

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5511

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4045

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3645

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2877

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General