Database

David Mujica wrote:

I agree with Eddy, this is not a performance problem, seems more like a poor implementation of user requirements.

David Mujica wrote:

Really ? Does the user need to see all of that data ?

sql_connection = new MySqlConnection("server = 10.0.0.111; Port = 3306; Database = bizcards; Uid = root; Pwd = mujtaba; SslMode = Preferred;");

DENY UPDATE, DELETE ON MyTable TO MyUser

B413 wrote:

Is this realizable in term of performance, size of data, queries

Jörgen Andersson wrote:

Did you just recommend the use of a trigger

CREATE TABLE statuser
	([userid] int)
;
	
INSERT INTO statuser
	([userid])
VALUES
	(1),
	(2)
;

CREATE TABLE stat
	([userid] int, [status] int, [startdate] date)
;
	
INSERT INTO stat
	([userid], [status], [startdate])
VALUES
	(1, 1, '2012-05-30'),
	(1, 2, '2013-06-23')
;
with maxstat as (
    select  s.userid,max(startdate) startdate
    from    statuser su
    left outer join stat s
        on  su.userid = s.userid
    group by s.userid
    )
select  s.userid,s.status,s.startdate
from    maxstat m
join stat s
    on  m.userid = s.userid
    and m.startdate = s.startdate