Article

2003-07-25

Archived material is restricted to Rantburg regulars and members. If you need access email fred.pruitt=at=gmail.com with your nick to be added to the members list. There is no charge to join Rantburg as a member.

Posted by Fred Pruitt 2003-07-25 11:31|| || Front Page|| [1 views since 2007-05-07] Top

#1 Are you doing this through a stored proc? You can return multiple result sets and avoid hitting the database with multiple calls, depending on what tech you're using.

E.g. CREATE PROCEDURE [spRantburg_Populate] AS
Select Title, Body from tblArticles
Select Count(*), TimeStamp from tblComments where blah, blah

Then in code:
Set adoRecordset = adoRecordSet.NextRecordset

Posted by Dar 2003-7-25 11:40:55 AM|| 2003-7-25 11:40:55 AM|| Front Page Top

#2 MySQL doesn't support stored procedures. Dammit.

Posted by Fred 2003-7-25 11:51:41 AM|| 2003-7-25 11:51:41 AM|| Front Page Top

#3 I've been thinking about migrating to SQL Server, but when I put the 'burg on our own web server I got SQL Slammed within 24 hours. I'm building a swap machine now, with more protection than we had when we first went up -- now it's a matter of not wating to rewrite an awful lot of SQL.

Posted by Fred 2003-7-25 11:55:02 AM|| 2003-7-25 11:55:02 AM|| Front Page Top

#4 When populating this page, I expect you do return one set for the header (article titles), one set for the categories on the right-hand margin (Europe, Fifth Column, etc.), and then one for the articles and comments, so it would save some time in general, although it may not be applicable to the change you described. Sounds like the change you're describing is an additional join?

Posted by Dar 2003-7-25 12:43:36 PM|| 2003-7-25 12:43:36 PM|| Front Page Top

#5 Time to hit the tip jar, ladies and gents...

Posted by seafarious 2003-7-25 12:46:40 PM|| 2003-7-25 12:46:40 PM|| Front Page Top

#6 I can see it now, ~~Aris~~ Anonymous will go back and post on everything for the previous day. Now he can be sure he got the last word with just a glance.

BTW, Fred, it looks SCSI - to use the Jobs pronunciation. You da man!

And if you'll hook up with Amazon, I'll be very happy to hit the tip jar - with a hat tip to seafarious! PayPal doesn't work for me, as is the case with many thousands of others, and they can't figure it out.

Posted by PD 2003-7-25 2:18:52 PM|| 2003-7-25 2:18:52 PM|| Front Page Top

#7 Your wish = my command...

Posted by Fred 2003-7-25 3:38:59 PM|| 2003-7-25 3:38:59 PM|| Front Page Top

#8 SQL gurus do it with joins

Posted by mojo 2003-7-25 4:13:56 PM|| 2003-7-25 4:13:56 PM|| Front Page Top

#9 The changes are great. Is it possible to put the name and time of the last updated comment up top beside each article heading?

Posted by Zhang Fei 2003-7-25 6:07:16 PM|| 2003-7-25 6:07:16 PM|| Front Page Top

#10 I like it. Now I can see when Al-Aska Paul has taken time off from designing hydraulics to post a response - heh heh. BTW Fred - I tipped $25 earlier this week - I encourage the rest of you 'burgers to give early and often ;-)
Frank

Posted by Frank G 2003-7-25 7:33:36 PM|| 2003-7-25 7:33:36 PM|| Front Page Top

#11 And I thank you for it. I now have a new hard drive and more memory, going into the swap machine at this moment.

Not sure there's room to put the info up top... Unless I use tiny text...

Posted by Fred 2003-7-25 8:08:30 PM|| 2003-7-25 8:08:30 PM|| Front Page Top

#12 I just deposited 25 clams in the tip jar. Hope that helps with expenses.

Posted by Zhang Fei 2003-7-25 8:42:01 PM|| 2003-7-25 8:42:01 PM|| Front Page Top

#13 Thank you. It helps!

Posted by Fred 2003-7-25 11:22:00 PM|| 2003-7-25 11:22:00 PM|| Front Page Top

#14 I'm in - Thx for the Amazon link for us PayPal-challenged Rantburgers!

Posted by PD 2003-7-25 11:56:45 PM|| 2003-7-25 11:56:45 PM|| Front Page Top

00:38 PD
00:11 PD
00:01 PD
23:56 PD
23:46 PD
23:25 Alaska Paul
23:24 Frank G
23:22 Fred
23:14 Frank G
23:06 tu3031
23:03 tu3031
23:01 Old Patriot
22:57 11A5S
22:52 tu3031
22:41 tu3031
21:37 mom
21:31 Old Patriot
20:59 Alaska Paul
20:54 Zhang Fei
20:54 Alaska Paul
20:53 Frank G
20:52 Frank G
20:52 Frank G
20:51 Zhang Fei