By bamban on

I just want to know about views module, how keeps track all sql queries that I create ? Even I checked out to all table of views module on phpmyadmin I did not find anything about sql query so how it works excatly ? is there any information about that ? I'm Just Curious Thank you

⋅ Categories: Drupal 6.x

Comments

hershel’s picture

hershel commented

I'm not sure what you are asking but if you use the Preview feature on the Edit View page you can see the SQL used to generate the View at the bottom of the page.

AFAIK SQL queries are created in real time, not stored.

bamban’s picture

bamban commented

HershelSR, thank you for your answer you said that "SQL queries are created in real time, not stored." so how it keeps track all of views that we creat custom ?

pembeci’s picture

pembeci commented

The module doesn't store the SQL it will use but of course it stores the information what you entered at the Views UI for your custom views. When it needs it creates the query in realtime by using this data. There is also caching going on (views_object_cache) for faster processing. The custom view specific data is stored as BLOB (binary) at the database tables so it is hard to study them.

bamban’s picture

bamban commented

thank you pembeci I got it now