« previous next »
Pages: [1]

Author Topic: SQL Help  (Read 1451 times)

aquilmustafa

  • Full Member
  • ***
  • Posts: 121
    • View Profile
SQL Help
« on: December 26, 2018, 02:42:46 AM »
Hi,

I've used AHMI latest version with sql server 2014 express edition. i have total 4 AHMI SCADA running in 4 diffrent pc's. I've created tables in one of the 4 pc's and all AHMI's log data to that table.

Initially it worked fine but after some months data logging speed decreased drastically. I've cleared the tables to check if that increases the speed.

Can u help me with my problem or guide me to the right direction.
Logged

Archie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5322
    • View Profile
    • AdvancedHMI
Re: SQL Help
« Reply #1 on: December 26, 2018, 06:34:39 AM »
Does your table have a keyed and indexed column?
Logged

Phrog30

  • Guest
Re: SQL Help
« Reply #2 on: December 26, 2018, 08:36:17 AM »
Quote from: aquilmustafa on December 26, 2018, 02:42:46 AM
I've cleared the tables to check if that increases the speed.
Did it?

I'm assuming yes. You may need to look into partitioning.
« Last Edit: December 26, 2018, 08:43:00 AM by Phrog30 »
Logged

bachphi

  • Hero Member
  • *****
  • Posts: 671
    • View Profile
Re: SQL Help
« Reply #3 on: December 26, 2018, 11:37:44 AM »
Keyed and indexed column are important to DB performance, which reminded me of  an IT who used to work at BestBuy in Geek Squad, he claimed he is a DBA without certification, when I looked at his tables that he created, they are all without key and index.

Anyway, you might want to check into Buffer Pool Extension :
https://www.youtube.com/watch?v=xXALq9H3sxA
Logged
===================================================
This is NOT alt.read.my.mind.
No such thing is sh^t-for-brains unless you are posting to alt.read.my.mind.
===================================================
Pages: [1]
« previous next »