You can set it in bitcoin-qt's setting or in the config file.
Since you're using QT: Open the menu "Settings->Options...", then put a reasonable value in "Size of database cache".
More or less half of your RAM, depending on the usage.

That requires you to restart Bitcoin core as the red message below the setting will say.