• Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login
Netgate Discussion Forum
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Search
  • Register
  • Login

When to use mysql for user records

Scheduled Pinned Locked Moved Captive Portal
1 Posts 1 Posters 1.1k Views
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • V
    vickikumar
    last edited by May 7, 2013, 7:35 AM

    Hi, I am running a small coffee cafe where I have pfsense setup to offer free wi-fi access. Usually, only 4 -5 users are connected to wi-fi at any moment with addition of daily new users to be around 25 - 30. Since a new user is created with validity of no more than two days, and I am required to keep usage access record of each user for at least two months, is it good to use mysql in this scenario? What is the best way to achieve this in terms of resource usage?

    Thanks

    1 Reply Last reply Reply Quote 0
    1 out of 1
    • First post
      1/1
      Last post
    Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.
      This community forum collects and processes your personal information.
      consent.not_received