Hi all
first .. sorry 4 my english :)
i am web developer and using wordpress as framework for any Customized CMS i want build
if i want to make a video Cms for example and want to make keys for videos instead of ID'S
each video is post has ID , and Customfield ( "vkey" => "1A2B3C" )
each post will have the customfield ( "vkey" )
so i want to make a custom page to view video by key
example.com/vid/ANYKEYHERE
will take the key and QueryPost it
my question here if i will have more than 1,000,000 Videos [ POSTS ]
i looked up at ("POSTMETA") table structure @ wordpress database and ofcourse they cant make this field ("UNIQUE") or Indexed coz this field may have alot of similar values like values of key ( _edit_last )
so i think the query will look at all ("vkey") values to find the one matching the Key comes from URL
i ask about this coz this page will be the most visited page at the cms and we will have alot of visits when we lunch it
i hope that any body can get what i talk about .. coz i know my bad english :(
Thanks in Advance