SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 24/09/2017, 09:51 AM   #21
raydx
Huge Clucker
 
raydx's Avatar
 
Join Date: Feb 2017
Posts: 203
Reputation: 73
Default Re: Mysql work slow

I told you what is your problem, but you skipped my post and you are listening to this guys above.
Also, loading a lot of data will be always slow, mostly because of loops inside loading functions.
raydx is offline   Reply With Quote
Old 24/09/2017, 05:00 PM   #22
Mister0
Huge Clucker
 
Mister0's Avatar
 
Join Date: Aug 2015
Posts: 220
Reputation: 19
Default Re: Mysql work slow

Quote:
Originally Posted by raydx View Post
I told you what is your problem, but you skipped my post and you are listening to this guys above.
Also, loading a lot of data will be always slow, mostly because of loops inside loading functions.
Ok I got it, last questions what should I use to loadthe data?
cache_get_value_name_int
cache_get_value_name_float
or
cache_get_value_index_int
cache_get_value_index_float
Mister0 is offline   Reply With Quote
Old 24/09/2017, 05:29 PM   #23
raydx
Huge Clucker
 
raydx's Avatar
 
Join Date: Feb 2017
Posts: 203
Reputation: 73
Default Re: Mysql work slow

Value_index is faster, but you have to use field numbers instead of names.
So, you better use value_name.
raydx is offline   Reply With Quote
Reply

Thread Tools
Display Modes

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL too slow NikolaSRB Scripting Help 9 02/09/2017 12:59 PM
Mysql loading slow Dusan01 Scripting Help 2 14/02/2016 10:14 AM
MySQL running slow Luis- Scripting Help 1 12/05/2015 08:53 PM
MySQL slow? PowerPC603 Scripting Help 20 27/01/2014 08:40 PM
MySQL Query is to slow. Momo5000 Help Archive 8 27/03/2011 04:44 PM


All times are GMT. The time now is 09:26 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.