Multiple DB Requests

[renegaed]

I have used the module as per your readme.md as follows

app.use(express.cookieParser());
  app.use(express.session({
    secret: "keyboard cat",
    maxAge: new Date(Date.now() + 3600000),
    store: new MySQLSessionStore("dbname", "root", "root")
  }));

but when I refresh my home page my console is flooded with the following:

Executing: CREATE TABLE IF NOT EXISTS `Sessions` (`sid` VARCHAR(255), `expires` INTEGER, `json` TEXT, `id` INTEGER NOT NULL auto_increment , `createdAt` DATETIME NOT NULL, `updatedAt` DATETIME NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB;
MySQL session store initialized.
Executing: SELECT * FROM `Sessions` WHERE `sid`='rz3mEkGVadrJno11g4d7PAYA.L/xvqTVdFpJfxWBP8OqoSA/9T/4EqxmG3mygdU3k9uA' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: INSERT INTO `Sessions` (`sid`,`id`,`createdAt`,`updatedAt`,`expires`,`json`) VALUES ('aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ',NULL,'2012-06-25 18:42:09','2012-06-25 18:42:09',1340628130,'{\"lastAccess\":1340613729507,\"cookie\":{\"originalMaxAge\":14400000,\"expires\":\"2012-06-25T12:42:09.548Z\",\"httpOnly\":true,\"path\":\"/\"},\"user\":\"bob\"}');
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: UPDATE `Sessions` SET `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ',`expires`=1340628130,`json`='{\"lastAccess\":1340613729593,\"cookie\":{\"originalMaxAge\":14400000,\"expires\":\"2012-06-25T12:42:09.594Z\",\"httpOnly\":true,\"path\":\"/\"},\"user\":\"bob\"}',`id`=8,`createdAt`='2012-06-25 18:42:09',`updatedAt`='2012-06-25 18:42:09' WHERE `id`=8
Executing: UPDATE `Sessions` SET `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ',`expires`=1340628130,`json`='{\"lastAccess\":1340613729596,\"cookie\":{\"originalMaxAge\":14400000,\"expires\":\"2012-06-25T12:42:09.596Z\",\"httpOnly\":true,\"path\":\"/\"},\"user\":\"bob\"}',`id`=8,`createdAt`='2012-06-25 18:42:09',`updatedAt`='2012-06-25 18:42:09' WHERE `id`=8
Executing: UPDATE `Sessions` SET `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ',`expires`=1340628130,`json`='{\"lastAccess\":1340613729597,\"cookie\":{\"originalMaxAge\":14400000,\"expires\":\"2012-06-25T12:42:09.597Z\",\"httpOnly\":true,\"path\":\"/\"},\"user\":\"bob\"}',`id`=8,`createdAt`='2012-06-25 18:42:09',`updatedAt`='2012-06-25 18:42:09' WHERE `id`=8
Executing: UPDATE `Sessions` SET `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ',`expires`=1340628130,`json`='{\"lastAccess\":1340613729598,\"cookie\":{\"originalMaxAge\":14400000,\"expires\":\"2012-06-25T12:42:09.598Z\",\"httpOnly\":true,\"path\":\"/\"},\"user\":\"bob\"}',`id`=8,`createdAt`='2012-06-25 18:42:09',`updatedAt`='2012-06-25 18:42:09' WHERE `id`=8
Executing: UPDATE `Sessions` SET `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ',`expires`=1340628130,`json`='{\"lastAccess\":1340613729599,\"cookie\":{\"originalMaxAge\":14400000,\"expires\":\"2012-06-25T12:42:09.599Z\",\"httpOnly\":true,\"path\":\"/\"},\"user\":\"bob\"}',`id`=8,`createdAt`='2012-06-25 18:42:09',`updatedAt`='2012-06-25 18:42:09' WHERE `id`=8
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: SELECT * FROM `Sessions` WHERE `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ' LIMIT 1;
Executing: UPDATE `Sessions` SET `sid`='aIhKRvy7JcIozJb4bR0uXUzN.vy6qmUPV3Zh+BA1TW0xv9YS+p7JvWg/tzEkSlWldXyQ',`expires`=1340628130,`json`='{\"lastAccess\":1340613729683,\"cookie\":{\"originalMaxAge\":14400000,\"expires\":\"2012-06-25T12:42:09.687Z\",\"httpOnly\":true,\"path\":\"/\"},\"user\":\"bob\"}',`id`=8,`createdAt`='2012-06-25 18:42:09',`updatedAt`='2012-06-25 18:42:09' WHERE `id`=8

I know it has been a while since you last looked at this project but it would be fantastic i you could have a look at this. I really want to use mysql as a backend to manage my sessions and your module seems to be the only one out there that works. My only concern is why these repeating requests are occuring on each single page request?

Thank you.