LAG caused by SQL
2 Attachment(s)
i do apologize about my english.
I'm using the "Forum Mod" plugin you could see it at http://forums.alliedmods.net/showthread.php?t=5913 . The plugin is working and checking registrations but everytime when a player joins the server it freezes several times, briefly(lag). My sql server is a external server on the internet and my game server is at my home pc. I need your help because i dont know pawn and C++. But i'm also glad if you give me some tips, so i 'll try to fix it myself. Thank's |
Re: LAG caused by SQL
Code:
public bool:FMAPI_GetReggedInformation(const STEAMID[], const bool:LOOKFORGROUPS, &forum_account_id, forumname[32], groups[], const MAX_GROUPS) { |
Re: LAG caused by SQL
Well i was reading a lot cause i'm noob at scripting.. i think i've found the problem:
the problem seems "DBI". the solution? "SQLx" Can you help me to learn sqlx or show me the syntax? i 'll try to rewrite this plugin to use sqlx but i cant found any GOOD documentation. thank's |
Re: LAG caused by SQL
sqlx == php :D
|
Re: LAG caused by SQL
Well.... LOL....
i'll post here the old codes and my codes ok? i'm not a lazy boy.....:mrgreen:!! |
Re: LAG caused by SQL
OLD CODE
PHP Code:
|
Re: LAG caused by SQL
MY CODE
PHP Code:
|
Re: LAG caused by SQL
Is it ok? LOL i'm trying!
|
Re: LAG caused by SQL
What you need are threaded queries (Available with sqlx). Opposed to non-thread queries, they occur in a process parallel to the halflife one so their execution don't interrupt its flux. That makes their coding process harder and tedious. So, or you wait that someone recode the full plugin for you (what I doubt) or you pay for it.
|
Re: LAG caused by SQL
Do you speak portuguese Joaquim?
Can you explain me how to do it? |
| All times are GMT -4. The time now is 18:18. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.