dovars()

[filburt1]

Does calling dovars() repeatedly generate queries for each call, or only a query for the first one?

[Logician]

I guess only a query for the first call

[filburt1]

Good

[Xenon]

you could have seen that yourself:

PHP Code:

 global $DB_site,$replacementsetid,$gzipoutput,$gziplevel,$newpmmsg,$microstats;
  static $vars;

  if (connection_status()) {
    exit;
  }

  if (!isset($vars)) {
    $vars=$DB_site->query("SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'$replacementsetid') ORDER BY replacementsetid DESC,replacementid DESC");
  } else {
    $DB_site->data_seek(0,$vars);
  } 


$vars is declared static

[filburt1]

I know but I'm never sure on how vB's cache systems work

[Xenon]

*ggg*
confusion is always good, that's the fun we have on working with vb

[Logician]

Originally posted by Xenon
you could have seen that yourself:

hehe actually the question lies whether "$DB_site->data_seek(0,$vars);" part generates a query.. Its roots goes into deep inside db_mysql.php

confusion is always good, that's the fun we have on working with vb

How correct!

[Mystis]

Originally posted by Xenon
*ggg*
confusion is always good, that's the fun we have on working with vb

There's so much truth in that statement that my head hurts.

[Xenon]

i think you are right friend logician, but from a logical point of view, why should the use a static var, if it would always produce a query

@Mystis: thanx

[Logician]

Originally posted by Xenon
i think you are right friend logician, but from a logical point of view, why should the use a static var, if it would always produce a query

you have a point pal :glasses: