Author Topic: Slow Database  (Read 1157 times)

casinodragon

  • Newbie
  • *
  • Posts: 15
    • View Profile
Slow Database
« on: November 05, 2017, 10:18:29 AM »
Hello Corey,
i have a huge problem with the Database (or the Software) . If i want to add Players to the tournament and search them at the Database it takes terrible long to type the name. Even if i add a new player to the database it takes terrible long time between typing and writing. i have to wait after every single letter. So add a name takes about 3o secondes. Its a huge lag.
I treid this Workout :http://www.thetournamentdirector.net/forums/index.php?topic=5209.0 alreday..nothing happends.
It happend with Version 3.3 and now 3.4.
Version 3.4 crash when i try to get the stats statisic.
Im running Windows 10, TD 3.4 (3.3), Database include about 3.000 Players
« Last Edit: November 05, 2017, 10:27:19 AM by casinodragon »

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Slow Database
« Reply #1 on: November 06, 2017, 05:35:58 PM »
I think we've likely discussed this over email before (and if it was someone else I apologize), but I really don't know why this happens to you.  Yes, 3000 players will run more slowly than 30 or 300, but in my testing 3000 players was not remotely unusable or even annoying.

Quote
Even if i add a new player to the database it takes terrible long time between typing and writing. i have to wait after every single letter.

This sounds to me like something else is happening, but I don't know what.

Have you tried using a blank database and adding a player?  Do you see the same issue?  This is easy to test without losing anything.  Try this:

Select the Preferences tab.  Then press the Data Stores button.  Then press the New button.  This will open the "Add New Data Store" dialog.  Press the Browse button and browse to some known location (wherever you want to create a folder) and press the "Make New Folder" button.  Give the new folder a name, and then press the OK button.  You should now be back at the "Add New Data Store" dialog with the Folder and Name fields completed.  Press the OK button.  Next you should be prompted to initialize the new data store.  Press the Yes button.  Now you should be back on the Data Stores dialog, and your new Data Store should have been added.  Right-click on the new Data Store and select "Make Active".  Confirm it by pressing the Yes button.  Finally, press the OK button on the Data Stores dialog to make the switch to the new, empty data store.  At this point, you should exit the TD and start it again.  That will clear out any cached players from memory.  Now you're running with an empty database.  You can confirm this by selecting the Database tab.  Try adding a new player.  Do you get the same issue (slow typing)?

To go back to your 3000 player database, select the Preferences tab, press the Data Stores button, right-click on your previous Data Store (should be the Default at the top) and select Make Active, then press OK.

casinodragon

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: Slow Database
« Reply #2 on: November 07, 2017, 07:40:00 AM »
Hi Corey,
i tried it like u sayd with a new Database. No Problems with the new Database. The Problem must be my 4.900 Players Database. Even if i try to search a Player  in my old Database ist terrible slow. Any idea? The Problem with the lag Database was also at Version 3.3 But not such slow as in Version 3.4
Cz with Version 3.3 the Database start searching after i hit Return. With 3.4 it starts a live search with every single letter.
« Last Edit: November 07, 2017, 09:49:47 AM by casinodragon »

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Slow Database
« Reply #3 on: November 07, 2017, 12:13:52 PM »
Quote
Cz with Version 3.3 the Database start searching after i hit Return. With 3.4 it starts a live search with every single letter.

This is a preference.  Preferences tab -> Behavior category -> Automatically search as soon as text is entered

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Slow Database
« Reply #4 on: November 07, 2017, 12:19:27 PM »
i tried it like u sayd with a new Database. No Problems with the new Database. The Problem must be my 4.900 Players Database. Even if i try to search a Player  in my old Database ist terrible slow. Any idea?

Unfortunately no.  I just tried this with a database of 5000 players, on Windows 10 with IE 11.  Performance isn't ideal, to be sure.  However, opening the Add Players to Tournament dialog takes about 6 seconds before it is responsive.  After that, if I search it takes about 3 or 4 seconds for the list of players to update.  Again, not ideal, but certainly usable.  I can't imagine what is causing yours to take 30 seconds or more.

casinodragon

  • Newbie
  • *
  • Posts: 15
    • View Profile
Re: Slow Database
« Reply #5 on: November 08, 2017, 04:01:34 AM »
could it be a problem with umlauts (ö,ä,ü) ?
This week we get 2 crashes by using the stats.

Corey Cooper

  • Administrator
  • Hero Member
  • *****
  • Posts: 6216
    • View Profile
Re: Slow Database
« Reply #6 on: November 08, 2017, 04:05:33 PM »
could it be a problem with umlauts (ö,ä,ü) ?
This week we get 2 crashes by using the stats.

I doubt it.  Those characters are standard ASCII and aren't treated any differently than any other characters.  Even if they were Unicode, the TD shouldn't have a problem with them.