ansaurus

Question

advance click counter mysql or flat file

Answer 1

A:

SQL used with proper indices. SQL data are essentially stored on disk, what makes them more valuable is the fact indices make finding specific records/data faster.

Your scheme should look something like:

Links(id:int, href:string)
Clicks(link_id:int, time:int, counter:int)

msakr 2010-06-14 02:08:11

thanks for your respond and i already have the links table setup just want to add cliks

jay 2010-06-14 04:24:34

what am i doing wrong here?mysql_query("INSERT INTO views SET site_id='{$id}', time='{$time}' ON DUPLICATE KEY UPDATE views=views+1") or die('Could not update data: ' . mysql_error());

jay 2010-06-14 05:51:36

I've never encountered this syntax before but straight away I could tell that your Update subquery needs more work; eg, include the table name? views seems to be both a table AND a column? Isn't that a little ambiguous?

msakr 2010-06-14 10:20:55

thanks for the reply but i dont think you have use "ON DUPLICATE KEY UPDATE" before it was released on mysql 4.1, i think most people don't take the advantage of it

jay 2010-06-15 00:15:27

ansaurus

tags:

views:

answers:

advance click counter mysql or flat file

related questions