|
| |
|
|
hzarabet
Posts: 1598
From: New Milford CT USA
Status: offline
 |
Am I getting in over my head? - 6/21/2002 22:50:09
I am considering taking on a big project for my site. I guess I am asking if this is worth doing?
I have about 150 SELECT queries on my site. Many are spitting out multiple page results or limiting the amount of records returned. I am strongly considering recoding them to more traditional SQL from the DRW (on a diet) the way they are now. I believe the learning curve will be tremendous.
I have already completed all my UPDATE nad DELETE queries. Those were a piece of cake. Basically just the queries and that was it.
If I do go ahead with this, what SQL website could you recommend to help?
Thanks all
http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
|
|
|
|
hzarabet
Posts: 1598
From: New Milford CT USA
Status: offline
|
RE: Am I getting in over my head? - 6/22/2002 0:09:37
Well, I just spent the last couple of hours or so playing with this SQL code on my own. This does not seem like a productive way to spend many hours of time!
My goal is to decrease my code size. The 3 includes have a lot of extras stuff (it seems) and my thought was to just code in what I needed.
Forget it!
Now, it seems that it would be a lot simpler to leave the 3 includes and just get rid of those extra unused lines below the SQL query in the DRW (diet). Is THAT even worth doing?
http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
| |
|
|
|
Stuey
Posts: 203
From: Dudley West Midlands, United Kingdom
Status: offline
|
RE: Am I getting in over my head? - 6/22/2002 9:52:54
You have several options open to you but the decision has to be yours at the end of the day.
Putting the ASP on a diet does help performace I find and it's worth spending the time.
i tend to do when I have nothing better to do, Keep a note of all the scripts I've done in front page and then once every few weeks go through and do the diet.
But I have a large screen and I find it easier.
your site can be as complex as you want it just remember you have to weigh up the cost of what your doing in time. Try doing it for a day and monitor how much time is spent bug hunting as opposed to actually creating new features.
A wise man said:
If it ain't broke don't fix it ;o)
I hope I helped
Stuart Steele
stuart@stuweb.co.uk
http://www.stuweb.co.uk
| |
|
|
|
hzarabet
Posts: 1598
From: New Milford CT USA
Status: offline
|
RE: Am I getting in over my head? - 6/22/2002 10:01:09
I wholly agree about putting the DRW on a diet. That is a MUST for any SELECT query. FOr Example, one of my queries was originally returning 25 results in upwards of a minute without the diet. Now it is 10-15 seconds. 20 on a bad day.
I wanted to take it a step or two further and remove all the FP includes. But....it will be a teremendous amount of learning and THEN implementing. EEESH!
http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
| |
|
|
|
Spooky
Posts: 26630
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Am I getting in over my head? - 6/22/2002 18:51:54
Im not sure if you mean using asp more?
You would still continue using the same SQL strings, but any improvement in the speed of the code will impove the entire site.
However, it IS a lot if work, but once you have one working, efficient asp/database page, you can use the same format on each following page with minor differences.
It does sound like there is a noticeable performace hit already?
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
|
|
hzarabet
Posts: 1598
From: New Milford CT USA
Status: offline
|
RE: Am I getting in over my head? - 6/22/2002 21:09:59
I've been using the diet since my first ELECT querie almost 2 years ago. WHen I saw how slow it was without it is immediately became SOP.
Here's what I mean. I was using the basic DRW generated code (on a diet) for my UPDATES and DELETES. I now switch all of them over to :
<%
sQry="UPDATE SHL_ShoppingMall SET SHL_ShoppingMall.Reminder = 'Yes' WHERE EndDate <= dateadd(d,7, convert(char(24),getdate(),1)) AND Reminder = 'No' "
Set RS = Conn.Execute(sQry)
set rs=nothing
Conn.Close
Set Conn=nothing
%>
On pages with 25 UPDATE queiers I went from 25 DRW queries to a multipleUPDATE query like the one ablove. It only opens and closes once instead of 25 times.
I wanted to take the above UPDATE query format and use it for all my SELECT queries. Now we're talking a BIG job because record sets are involved, tables, cells, multiple page results, etc. etc. etc.
http://www.SigningsHotline.com lists EVERY upcoming athlete autograph appearance in the US and Canada
| |
|
|
|
Spooky
Posts: 26630
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Am I getting in over my head? - 6/22/2002 22:20:48
How much time do you have? :-)
I would start with a page that has a single result returned (no paging) as a test of how much you would need to do.
Take small easy steps!
For any type of performance, asp is going to be better than DRW.
I would recommend the .getrows method, but that also brings more difficulties as you need to be familiar with arrays.
If you are after performance, then thats the way to go.
One of the best sites around!
http://www.learnasp.com/learn/dbtablegetrows.asp
§þððk¥
Database / DRW Q & A
VP-ASP Shopping cart
Spooky Login
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 