MySQL - Question about Cache - Printable Version

MySQL - Question about Cache - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL - Question about Cache (/showthread.php?tid=515653)

MySQL - Question about Cache - Dragony92 - 27.05.2014

What happen with cache if i select few rows, and than i send new queries while i'm taking the data from that rows in loop...
Example code..

pawn Код:

mysql_tquery(mysql, "SELECT * FROM table", "SortData");

public SortData()
{
    for(i = 0; i < cache_get_row_count(); i++)
    {
        ...
        mysql_tquery(...);
        ...
    }
    return 1;
}

Do i lose cache from first query if i call a new one?

Re: MySQL - Question about Cache - Dragony92 - 28.05.2014

BUMP

Re: MySQL - Question about Cache - Vince - 28.05.2014

Not entirely sure, but what is it that you're trying to do? This function makes me think that the entire action should be handled by MySQL rather than in Pawn.

Re: MySQL - Question about Cache - Dragony92 - 28.05.2014

Getting data, analyzing, doing actions on server and then updating database...

Re: MySQL - Question about Cache - Dragony92 - 30.05.2014

BUMP