在winform中创建本地数据库，并在后台从服务器获取数据

我正在寻找一种方法来增强我的应用程序的性能，该方法过度使用了服务器上托管的数据库，因此该应用程序需要远程访问数据库，从而使其运行缓慢，因此我在考虑创建本地数据库，并在应用程序运行的那一刻从服务器填充数据库，然后每隔一小时或当用户决定注销后，定期对托管的mySQl数据库进行更新，我遇到的主要问题是我将拥有10- 20个用户，他们不会更新相同类型的数据，但是我怎么知道哪些表已更新，并据此我将这些更改应用于托管数据库？并且是否有任何文章或链接对此问题有进一步的解释？

我的应用程序是C＃Windows窗体应用程序，数据库是mysql数据库。

我拥有的且执行所需的时间太长的查询之一是：

 /**
  * getting the schedule based on the submitted id
  * */
    public static Schedule2 getTeachersSchedule(String therapistID, int weekday, int period, int school_year)
    {
        // connecting to mysql database
        try
        {
            using (MySqlConnection myConn = new MySqlConnection(connectionString))
            {
                using (MySqlCommand command = new MySqlCommand("Select * FROM student_schedule2, weekday, school_year, period, task where school_year_id = school_year_id_fk AND therapist_id_fk =" + therapistID + " AND weekday_id = weekday_id_fk AND period_id=period_id_fk AND task_id=task_id_fk AND weekday_id=" + weekday + " AND period_id=" + period + " AND school_year_id =" + school_year, myConn))
                {
                    MySqlDataReader reader;
                    myConn.Open();
                    reader = command.ExecuteReader();
                    Schedule2 schedule = null;
                    while (reader.Read())
                    {
                        schedule = new Schedule2();
                        schedule.ID = reader.GetInt32("student_schedule2_id");
                        try
                        {
                            if (reader["student_id_fk"] != DBNull.Value)
                                schedule.student = getStudent(reader.GetString("student_id_fk"));
                            else
                                schedule.student = null;
                            Weekday weekDay = new Weekday();
                            weekDay.ID = reader.GetInt32("weekday_id");
                            weekDay.weekdayName = reader.GetString("weekday_name");
                            schedule.weekday = weekDay;
                            schedule.semesterName = reader.GetString("semester_name");
                            Period periodObj = new Period();
                            SchoolYear schoolYEar = new SchoolYear();
                            periodObj.ID = reader.GetInt32("period_id");
                            periodObj.period_name = reader.GetString("period_name");
                            schedule.period = periodObj;
                            schoolYEar.ID = reader.GetInt32("school_year_id");
                            schoolYEar.year_name = reader.GetString("school_year_name");
                            schedule.schoolYear = schoolYEar;
                            Task course = new Task();
                            course.ID = reader.GetInt32("task_id");
                            course.taskName = reader.GetString("task_name");
                            schedule.task = course;
                            schedule.therapist = getTherapist(reader.GetString("therapist_id_fk"));
                        }
                        catch
                        {

                        }

                    }

                    myConn.Close();
                    return schedule;
                }
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
            return null;
        }
    }