vb3 longgest query ?

[deathemperor]

I assume it's for $post, it took me awhile reading it. however I haven't checked if it's the longgest.

Did someone happen to see one ?

[Dean C]

Find out by modifying db_mysql.php to strlen the incoming sql and log it in the cache I'll be damned if i'm looking through all those files

[deathemperor]

good point. I just wanted to know if someone found it while coding in to vb

[filburt1]

Originally Posted by deathemperor

I assume it's for $post, it took me awhile reading it. however I haven't checked if it's the longgest.

Did someone happen to see one ?

I can upload a 1 GB file and make a query that is longer than 1,073,741,824 characters.

[Guy G]

Originally Posted by filburt1

I can upload a 1 GB file and make a query that is longer than 1,073,741,824 characters.

hmm..... and what does the query does ?
:P

[Erwin]

What do you mean longest query? Check your mysql slow_query log?

[deathemperor]

Originally Posted by filburt1

I can upload a 1 GB file and make a query that is longer than 1,073,741,824 characters.

I was asking for vb's queries...

Originally Posted by Erwin

What do you mean longest query? Check your mysql slow_query log?

I meant the longest query that vb uses to collect data from db, it has some inner, left joins and a bunch of conditional, I've seen one very big for $post, just wonder which is the biggest.