The Arcive of vBulletin Modifications Site.

deathemperor · #1 01-21-2005, 10:04 AM

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 · #2 01-21-2005, 02:15 PM

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 · #3 01-22-2005, 03:46 AM

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

filburt1 · #4 01-22-2005, 04:47 AM

Quote:

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 · #5 01-22-2005, 07:36 AM

Quote:

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 · #6 01-22-2005, 10:55 AM

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

deathemperor · #7 01-24-2005, 03:59 AM

Quote:

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

Quote:

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.