|
 |
asp_databases thread: web page creation
Message #1 by Simon Newton <simonn@h...> on Wed, 25 Jul 2001 07:02:19 +1000
|
|
Anyone had experience with full web site population from SQL? we need to
find the "best" methods:
including:
table structures, relational or flat data?
should we use views and/or stored procedures or only asp code?
methods of populating the database?
any hints, tricks or warnings about traps would be greatly appreciated.
Simon.
Message #2 by "Ken Schaefer" <ken@a...> on Wed, 25 Jul 2001 12:34:09 +1000
|
|
Very broad hints, since there is a paucity of detail in your post:
Normalise data, unless you have a good reason not to (eg to speed up your
site)
Always use sprocs. Grant Exec rights to the necessary user on the sprocs -
this way if your user account is compromised, at worst, all that can happen
is that the attacker can run the sprocs. As well, sprocs are by and large
faster than SQL statements
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Simon Newton" <simonn@h...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, July 25, 2001 7:02 AM
Subject: [asp_databases] web page creation
: Anyone had experience with full web site population from SQL? we need to
: find the "best" methods:
:
: including:
:
: table structures, relational or flat data?
:
: should we use views and/or stored procedures or only asp code?
:
: methods of populating the database?
:
: any hints, tricks or warnings about traps would be greatly appreciated.
Message #3 by Simon Newton <simonn@h...> on Wed, 25 Jul 2001 13:15:08 +1000
|
|
ken, just on entering data from the site (a page)...
If i have a large normalised database how do i structure my UPDATES
(perhaps
as stored procedures) so that the primary key (which is an incremental
identity seed) of the main table is caught by the other relational
tables
and populate the correct rows as a foreign keys...
hope that's a bit clearer then mud..
Simon.
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Wednesday, 25 July 2001 12:34
To: ASP Databases
Subject: [asp_databases] Re: web page creation
Very broad hints, since there is a paucity of detail in your post:
Normalise data, unless you have a good reason not to (eg to speed up
your
site)
Always use sprocs. Grant Exec rights to the necessary user on the
sprocs -
this way if your user account is compromised, at worst, all that can
happen
is that the attacker can run the sprocs. As well, sprocs are by and
large
faster than SQL statements
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Simon Newton" <simonn@h...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, July 25, 2001 7:02 AM
Subject: [asp_databases] web page creation
: Anyone had experience with full web site population from SQL? we need
to
: find the "best" methods:
:
: including:
:
: table structures, relational or flat data?
:
: should we use views and/or stored procedures or only asp code?
:
: methods of populating the database?
:
: any hints, tricks or warnings about traps would be greatly
appreciated.
|
|
|
View Cart
