Staredit Network > Forums > Staredit Network > Topic: Slow SEN login
Slow SEN login
Aug 18 2010, 12:25 am
By: Aristocrat  

Aug 18 2010, 12:25 am Aristocrat Post #1



In the time it took me to log into SEN I managed to install four applications and crack one. Why does SEN take a whole three minutes to process my login request?



None.

Aug 18 2010, 12:38 am BlueWolf Post #2



I only get long logins when I have cleared all of my browsing history.



None.

Aug 18 2010, 12:41 am Vincent Post #3



Maybe you're just super far from where the host server is located.



None.

Aug 18 2010, 12:45 am Aristocrat Post #4



Quote from Vincent
Maybe you're just super far from where the host server is located.

I really don't think the problem has to do with distance to SEN. Pages load instantly for me after I have logged in, it's just the process of actually logging in that seems to cause SEN to become unloadable for an intolerable amount of time.



None.

Aug 18 2010, 12:55 am Wing Zero Post #5

Magic box god; Suck it Corbo

Once you are logged in there is no lag, Its just the log in process that does that. i don't know why it happens but once you set it to permanent log in the site doesn't lag at all. I have the same problem but an interesting thing is if you click on a link to another page on the site you will jump there logged in. Its one way so work around the log in time.




Aug 18 2010, 2:03 am Devourer Post #6

Hello

It's a known bug already, yet I'm not sure what causes it, especially as it is rather random: some do lag, some don't.



Please report errors in the Staredit.Network forum.

Aug 18 2010, 2:07 am Aristocrat Post #7



Quote from Devourer
It's a known bug already, yet I'm not sure what causes it, especially as it is rather random: some do lag, some don't.

If by some draconian block of terrible code it's iterating through each member starting with mid=1, a member with high ID could take a long time to log in while someone like DTBK with a 2-digit ID would require less than 1/100ths as many SQL queries. I highly doubt that retrieving a member ID given name would be implemented this poorly, but it's a potential cause.



None.

Aug 18 2010, 2:20 am Apos Post #8

I order you to forgive yourself!

Quote from Aristocrat
Quote from Devourer
It's a known bug already, yet I'm not sure what causes it, especially as it is rather random: some do lag, some don't.

If by some draconian block of terrible code it's iterating through each member starting with mid=1, a member with high ID could take a long time to log in while someone like DTBK with a 2-digit ID would require less than 1/100ths as many SQL queries. I highly doubt that retrieving a member ID given name would be implemented this poorly, but it's a potential cause.
AFAIK, you can just search the username with only one SQL query. (I hope that's how it's done :P) People like me would take 5006 query just to log in.




Aug 18 2010, 2:22 am Aristocrat Post #9



Quote from Apos
Quote from Aristocrat
Quote from Devourer
It's a known bug already, yet I'm not sure what causes it, especially as it is rather random: some do lag, some don't.

If by some draconian block of terrible code it's iterating through each member starting with mid=1, a member with high ID could take a long time to log in while someone like DTBK with a 2-digit ID would require less than 1/100ths as many SQL queries. I highly doubt that retrieving a member ID given name would be implemented this poorly, but it's a potential cause.
AFAIK, you can just search the username with only one SQL query. (I hope that's how it's done :P)

Exactly, that's why I was so baffled by this ridiculous slowdown. But considering IP...

*shudders*



None.

Aug 18 2010, 6:22 am Centreri Post #10

Relatively ancient and inactive

This was discussed before and the same potential problem was thought up. Since it wasn't fixed, I assume that isn't it.



None.

Aug 18 2010, 3:19 pm Devourer Post #11

Hello

.... seriously.
The high member id got absolutely nothing to do with the lag. SELECT * FROM table_name WHERE name={$_POST['name']}. Similar to this, SEN's fetching for login is coded. As you can see, the ID has nothing to do with it.

And "considering IP..."... dude, you are not even long enough here to know him or his coding for real, lol.



Please report errors in the Staredit.Network forum.

Aug 18 2010, 5:23 pm Apos Post #12

I order you to forgive yourself!

Quote from Devourer
And "considering IP..."... dude, you are not even long enough here to know him or his coding for real, lol.
That was supposed to be a compliment :bleh:

Edit:
Also, just to clarify, the lag could have been caused by a loop going through all the members IDs one after the other and verify the username which would have caused the page to take a way longer loading time for members with a higher ID.

Post has been edited 1 time(s), last time on Aug 18 2010, 5:31 pm by Apos.




Aug 18 2010, 7:25 pm Moose Post #13

We live in a society.

There is no ridiculous code for looking up which member is logging in.
The slow-down stems to be security-related and anti-proxy measures and was on IP's personal to-do list. (and I don't intend on touching it because he would understand it way better than me in addition to having coded it himself)




Aug 18 2010, 7:53 pm Ahli Post #14

I do stuff and thingies... Try widening and reducing the number of small nooks and crannies to correct the problem.

Perfect fix: stay logged in.

Oh, and can you remember the time when people somehow logged in as another persons and post in their name?
Be happy that isn't the case anymore. :D




Aug 18 2010, 11:05 pm shmeeps Post #15



Quote from Devourer
.... seriously.
The high member id got absolutely nothing to do with the lag. SELECT * FROM table_name WHERE name={$_POST['name']}. Similar to this, SEN's fetching for login is coded. As you can see, the ID has nothing to do with it.

And "considering IP..."... dude, you are not even long enough here to know him or his coding for real, lol.
Not only that, but I believe MySQL uses Hash Tables, which brings the search time to practically nil, compared with others



None.

Aug 19 2010, 11:24 am Leeroy_Jenkins Post #16



Quote from Aristocrat
In the time it took me to log into SEN I managed to install four applications and crack one. Why does SEN take a whole three minutes to process my login request?
You're not alone.
http://www.staredit.net/topic/11908/0/



None.

Aug 19 2010, 1:48 pm Aristocrat Post #17



Ah now I remember, I even posted in that topic, too. Silly me.

On a separate note:




...is what happens when I try viewing SEN. The site is functional in this state, but still, really?

EDIT> Seems like this was temporary, the site is back to normal now. What did you guys do? O.o



None.

Aug 19 2010, 2:07 pm Devourer Post #18

Hello

It's called CSS. When uploading a new CSS the old one gets removed and then the new one gets uploaded, when you load SEN in exactly that time you get these errors, it's the same with PHP.



Please report errors in the Staredit.Network forum.

Options
  Back to forum
Please log in to reply to this topic or to report it.
Members in this topic: None.
[09:38 pm]
NudeRaider -- Ultraviolet
Ultraviolet shouted: NudeRaider sing it brother
trust me, you don't wanna hear that. I defer that to the pros.
[07:56 pm]
Ultraviolet -- NudeRaider
NudeRaider shouted: "War nie wirklich weg" 🎵
sing it brother
[2024-4-27. : 6:24 pm]
NudeRaider -- "War nie wirklich weg" 🎵
[2024-4-27. : 3:33 pm]
O)FaRTy1billion[MM] -- o sen is back
[2024-4-27. : 1:53 am]
Ultraviolet -- :lol:
[2024-4-26. : 6:51 pm]
Vrael -- It is, and I could definitely use a company with a commitment to flexibility, quality, and customer satisfaction to provide effective solutions to dampness and humidity in my urban environment.
[2024-4-26. : 6:50 pm]
NudeRaider -- Vrael
Vrael shouted: Idk, I was looking more for a dehumidifer company which maybe stands out as a beacon of relief amidst damp and unpredictable climates of bustling metropolises. Not sure Amazon qualifies
sounds like moisture control is often a pressing concern in your city
[2024-4-26. : 6:50 pm]
Vrael -- Maybe here on the StarEdit Network I could look through the Forums for some Introductions to people who care about the Topics of Dehumidifiers and Carpet Cleaning?
[2024-4-26. : 6:49 pm]
Vrael -- Perhaps even here I on the StarEdit Network I could look for some Introductions.
[2024-4-26. : 6:48 pm]
Vrael -- On this Topic, I could definitely use some Introductions.
Please log in to shout.


Members Online: Oh_Man