Author |
Topic |
Nathan
Help Moderator
USA
7664 Posts |
|
Nathan
Help Moderator
USA
7664 Posts |
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 26 April 2002 : 10:13:10
|
This week was blown away when my host lost his server and I had to scramble to find a new one and set my whole site up again :( .. not helping that was the fact that my new host is only running SQL7 and my DB was setup for SQL2000 using nice things like CASCADING INSERT and DELETE Relationships, which of course SQL7 does not support
www.daoc-halo.com |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 26 April 2002 : 11:12:28
|
Nathan yes, sorry forgot to post, basically you need to add a clustered index to the sort field you use in active_users.asp in mine it is dateCreated but may be different in yours, this seems to have sorted it out.
However, for low volume sites it should not be necesary.
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 26 April 2002 : 18:46:28
|
I am still a bit stupid on clustered index.
Is it as simple as adding an ID column to the ACTIVE_USERS table and using that for the update in inc_functions.asp? Or do I need to do somthing else.
Nathan Bales Snitz Exchange | Do's and Dont's |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 27 April 2002 : 00:30:44
|
My version of AU4 doesn't have any sorting in active_users.asp. Did you add the sorting yourself Huw (and therfore perhaps create the locking problem yourself too ) or am I just not using the most recent version of active_users.asp ?... or the third and more likey option ... am I just going nuts fullstop.
www.daoc-halo.com
Edited by - Gremlin on 27 April 2002 00:31:00 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 27 April 2002 : 00:42:23
|
Yea, AU4 isn't currently sorted at all . . . didn't think it was nessisary.
Nathan Bales Snitz Exchange | Do's and Dont's |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 April 2002 : 02:17:36
|
quote:
My version of AU4 doesn't have any sorting in active_users.asp. Did you add the sorting yourself Huw (and therfore perhaps create the locking problem yourself too ) or am I just not using the most recent version of active_users.asp ?... or the third and more likey option ... am I just going nuts fullstop.
www.daoc-halo.com
Edited by - Gremlin on 27 April 2002 00:31:00
No, I didn't have any, I added one, I thought that is what I said.
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 27 April 2002 : 02:23:21
|
K, so adding an AU_ID column and using it to sort on Active.asp and for the update statments. That should prevent this problem.
*Wants to be sure*
Nathan Bales Snitz Exchange | Do's and Dont's |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 27 April 2002 : 04:36:59
|
EDIT: My mother always said think before you speak, maybe one day I'll learn too. the below wont work becuase its not unique, I'd forgotten about Guests having MemberId = 0
Instead I've added an Autonumber AU_ID field and made it the PK on my live site, I'll let you know if I encounter any problems
Just an PK index on MEMBER_ID might suffice, I dont see the need for a an extra column or any sort orders to be put in, but then Huw seems to be on a different track to me here so I'll just let him have the last word I guess
www.daoc-halo.com
Edited by - Gremlin on 27 April 2002 05:03:30 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 27 April 2002 : 06:29:32
|
A clustered index may be overkill here, since it's not likely that this table will have that many records, but it will sure speed things up a bit. Anyway this small number of records will also mean that the disadvantages usually associated with clustered indexes likely won't show up either.
------------------------------------------------- Installation Guide | Do's and Dont's | MODs |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 27 April 2002 : 06:48:37
|
quote:
Have you ever stopped to think. . . and forgot to start again?
Nathan Bales Snitz Exchange | Do's and Dont's
ROFL .. yes I stoped a coulple of weeks ago ... damm thats what I forgot to do, Start again !! heh thanks for reminding me Nath
www.daoc-halo.com |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 27 April 2002 : 15:18:17
|
So. . . I still dont knwo the difference between a clustered index and a regular id/index. . .
Nathan Bales Snitz Exchange | Do's and Dont's |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
Topic |
|