Raised This Month: $ Target: $400
 0% 

3d Array saving (MySQL) [90 Queires?]


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Black Rose
Veteran Member
Join Date: Feb 2011
Location: Stockholm, Sweden
Old 06-27-2014 , 07:39   Re: 3d Array saving (MySQL) [90 Queires?]
Reply With Quote #1

Afaik, you have these options:
1. Place everything on one row in the table.
2. Send stacked queries (by adding them after each other within the same string). I don't know how the AMXX SQL core will handle it though. It may split them before sending.
3. Send the SQL queries instantly instead of buffering them until the end of the map. The count will increase, but the stream will be more even.
4. Store the information locally in a file or a vault before mapchange and then once the map starts, send the stored queries one by one.

Personally I would experiment with the fourth option because it sounds interesting.
__________________

Last edited by Black Rose; 06-27-2014 at 07:41.
Black Rose is offline
Reply



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:51.


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