Raised This Month: $ Target: $400
 0% 

Lag on connect caused by SQL - need help.


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Sylwester
Veteran Member
Join Date: Oct 2006
Location: Poland
Old 07-04-2009 , 13:05   Re: Lag on connect caused by SQL - need help.
Reply With Quote #8

I used same sql requests and I detect if you have already voted in the same way. If the old version worked then I'm not sure why this is not working.

You can try to set 2 primary keys (replace line):
PHP Code:
format(cache127"CREATE TABLE IF NOT EXISTS %s (steamid TEXT(32),mapname TEXT(32),rate INT(11), PRIMARY KEY (steamid, mapname))",Table
I'm not sure if this one will fix the problem (make sure you delete old table from database before you try this).

You can also create separate table for each map and store only steamid and rating and use 1 primary key.
__________________
Impossible is Nothing
Sylwester is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 15:34.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode