PDA

View Full Version : Problems with referring links from google images


Vilmis
01-07-2008, 12:46 AM
It looks like in SC4 you increased field size for storing referring urls in DB, but size is still too small for referrals coming from google images.
Here is example:
This url I can see in SC4
http://images.google.lt/imgres?imgurl=http://vilmis.com/photos/albums/uploads/20070915_Tonga/vavau/normal_20070916_Vavau_009_800.jpg&imgrefurl=http://www.vilmis.com/blogas/2007/09/15/banginiu-medziokle-tongoje/&h=399&w=600&sz=30&hl=lt&start=2&um=1&tbnid=O
it is 255 characters.

But full url in my web server's log is
http://images.google.lt/imgres?imgurl=http://vilmis.com/photos/albums/uploads/20070915_Tonga/vavau/normal_20070916_Vavau_009_800.jpg&imgrefurl=http://www.vilmis.com/blogas/2007/09/15/banginiu-medziokle-tongoje/&h=399&w=600&sz=30&hl=lt&start=2&um=1&tbnid=OiYxRBhLChQYPM:&tbnh=90&tbnw=135&prev=/images%3Fq%3Dsm%25C4%2597lio%2Bkr%25C5%25ABva%26nd sp%3D18%26svnum%3D10%26um%3D1%26hl%3Dlt%26lr%3Dlan g_lt%26client%3Dfirefox-a%26rls%3Dorg.mozilla:lt:official%26hs%3DkWz%26sa% 3DN
i.e. 470 characters and I am sure it can be even bigger.

webado
01-07-2008, 01:33 AM
Technically a url that Google indexes can be up to 2048 characters long.

There's no way Statcounter can reserve that much space for urls, I don't think.

Vilmis
01-07-2008, 01:49 AM
Technically a url that Google indexes can be up to 2048 characters long.

There's no way Statcounter can reserve that much space for urls, I don't think.

You most likely using VARCHAR for storing urls, i.e. it wouldn't take all 2048 characters, only as much as it needs. But of course you have much more statistics to predict how much space it would take.

Biggest problem is, that I cann't see keywords when url is truncated.

webado
01-07-2008, 01:56 AM
No idea what's used, but indeed predicting space requirements would be a headache without setting some limits.

Vilmis
01-07-2008, 02:03 AM
No idea what's used, but indeed predicting space requirements would be a headache without setting some limits.

I hope somebody who knows DB structure will check this thread.