| Author |
 Topic  |
|
GauravBhabu
Advanced Member
4288 Posts |
 Posted - 17 August 2002 : 23:32:56
|
quote:
Static and keyset-driven client-side cursors may place a significant load on your workstation if they include too many rows.
With a client-side Cursor, the page load time may vary from client to client.
However using a server-side cursor will always use the server resources, temporarily, for each client. |
 |
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 17 August 2002 : 23:39:39
|
There is no specific criteria on using the Cursors. Different applications will perform differently using similar Cursor settings. It will more appropriate to use the settings which are more suited to a application.
[quote]
Not all applications need to use cursors to access or update data... Cursors should be one of the last techniques you choose to retrieve data—and then you should choose the lowest impact cursor possible. |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 17 August 2002 : 23:48:07
|
I see the following in active.asp for this topic, but I do not see the post.
17 August 2002 23:41:03
by: ruirib |
CSS and HTML4.01 Compilant Snitz Forum . ForumSquare . Rakesh Jain
It is difficult to IMPROVE on Perfection, There is no harm in Keep Trying.
Prayer Of Forgiveness "I forgive all living beings. May all living beings forgive me!
I cherish the friendliness towards all and harbour enmity towards none." -- Aavashyaka Sutra(Translated) |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 17 August 2002 : 23:51:39
|
quote:
Originally posted by GauravBhabu
I see the following in active.asp for this topic, but I do not see the post.
17 August 2002 23:41:03
by: ruirib
I edited a previous post to clarify something I had written before. That's why you cannot see my post. I think the last post link takes you to the proper place though. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 17 August 2002 : 23:55:08
|
I do not see any edited post at that time within this topic or I missed. Did you edit a post in another topic? If so than why the Last post by time showed in the cloumn for this Topic.
Okay i see it now |
Edited by - GauravBhabu on 17 August 2002 23:57:47 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 August 2002 : 00:12:36
|
Ok, it seems Microsoft's Web Stress Tool refuses to cooperate with me on this. It is crashing repeatedly so I guess I will not web stress test my cursor test pages.
Anyway I agree with Gaurav's remarks about each application having to find out what are the best settings for itself. With Snitz, probably server side cursors are better, if my tests can be confirmed, but even that may not be true. For a scenario with different Web and database servers, it may be found that the gainings in scalability outweight the speed difference (which is not really that big anyway).
|
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 18 August 2002 00:14:06 |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 18 August 2002 : 00:24:40
|
As the Client-Side Cursors can only be Static (at least at present), so the only comparison to be made is, whether to use Static Cursor Type on Client-Side or Server-Side.
In cases where no paging, moving between the records is required or no changes to the database are required to be made, the best option is to use
Server-Side Forward Only Cursor. |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
Posted - 18 August 2002 : 07:10:39
|
Oh I got an achy head reading all that! 
Did my suggestion do any good in the end?  |
Snitz 'Speedball' : Site Integration Mod : Friendly Registration Mod
"In war, the victorious strategist only seeks battle after the victory has been won" |
Edited by - D3mon on 18 August 2002 07:10:55 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 August 2002 : 11:12:06
|
quote:
Originally posted by D3mon
Oh I got an achy head reading all that!
Did my suggestion do any good in the end?
If you read this you'll see that Richard applied it throughout the Snitz code, even if with a slightly different look from your initial suggestion. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
D3mon
Senior Member
United Kingdom
1685 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 12:06:54
|
quote:
Originally posted by RichardKinser
this is what I used in my global.asa file:
<!--METADATA TYPE="TypeLib"
uuid={00000200-0000-0010-8000-00AA006D2EA4}
-->
and it's used on this site as well.
But, we can't expect that everyone will have this in their global.asa file. So, there is no way that we can use the ADO constants and make sure that everyone will be able to use them without errors.
quote:
Originally posted by GauravBhabu
It can be added in config.asp.
quote:
Originally posted by Gremlin
If you put the metatag in config.asp then there should be no errors, even if it is already also defined in global.asa I believe.
quote:
Originally posted by GauravBhabu
Yes, It won't give any errors.
Well, with the errors that some users have been posted, it seems like this isn't the case. |
|
|
|
GauravBhabu
Advanced Member
4288 Posts |
Posted - 19 August 2002 : 12:16:20
|
| Just to test again, I added the Metadata to the top of active.asp in addition to config.asp and get no errors. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 19 August 2002 : 12:20:10
|
| yes, but it looks like some people don't have this library installed on their servers. So including it is causing problems. Which is one of the reasons I had used the numerical value instead of the Name, everyone would be able to use it. Looks like I'll have to go back through the code and change them all back. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 August 2002 : 13:10:16
|
quote:
Originally posted by RichardKinser
yes, but it looks like some people don't have this library installed on their servers. So including it is causing problems. Which is one of the reasons I had used the numerical value instead of the Name, everyone would be able to use it. Looks like I'll have to go back through the code and change them all back.
Richard maybe you can include adovbs.inc with the Snitz code and just add a include for it in config.asp. That will spare you the changes to the code, that enhance readability. You can then remove the metadata. Including adovbs.inc will work for everyone. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 19 August 2002 13:15:12 |
|
|
|
Topic |
|
Topic Locked
Ah! that's fantastic!