MyBB Community Forums
What does "Optimize Databases" do? - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: What does "Optimize Databases" do? (/thread-214022.html)



What does "Optimize Databases" do? - Michael2014 - 2017-11-10

What does optimize databases do and what risk is there to the site if one was to optimize the databases in admin panel?


RE: What does "Optimize Databases" do? - Livewire - 2017-11-10

Quote:Specific bits of data are accessed by queries written in a particular interface language, such as SQL. Database optimization involves maximizing the speed and efficiency with which data is retrieved. Database designers, administrators and analysts work together to optimize system performance through diverse methods.



RE: What does "Optimize Databases" do? - Michael2014 - 2017-11-10

(2017-11-10, 07:47 PM)Livewire Wrote:
Quote:Specific bits of data are accessed by queries written in a particular interface language, such as SQL. Database optimization involves maximizing the speed and efficiency with which data is retrieved. Database designers, administrators and analysts work together to optimize system performance through diverse methods.

Hi, thanks for the response!
Ive read threads where people have optimized their datebase in admin cp and in messed up their site.


RE: What does "Optimize Databases" do? - Livewire - 2017-11-11

(2017-11-10, 11:40 PM)Michael2014 Wrote:
(2017-11-10, 07:47 PM)Livewire Wrote:
Quote:Specific bits of data are accessed by queries written in a particular interface language, such as SQL. Database optimization involves maximizing the speed and efficiency with which data is retrieved. Database designers, administrators and analysts work together to optimize system performance through diverse methods.

Hi, thanks for the response!
Ive read threads where people have optimized their datebase in admin cp and in messed up their site.

I've always optimized mines nothing happened to my site. :/


RE: What does "Optimize Databases" do? - Michael2014 - 2017-11-11

(2017-11-11, 03:56 PM)Livewire Wrote:
(2017-11-10, 11:40 PM)Michael2014 Wrote:
(2017-11-10, 07:47 PM)Livewire Wrote:
Quote:Specific bits of data are accessed by queries written in a particular interface language, such as SQL. Database optimization involves maximizing the speed and efficiency with which data is retrieved. Database designers, administrators and analysts work together to optimize system performance through diverse methods.

Hi, thanks for the response!
Ive read threads where people have optimized their datebase in admin cp and in messed up their site.

I've always optimized mines nothing happened to my site. :/

What good does it do for your site?


RE: What does "Optimize Databases" do? - Corey H - 2017-11-11

(2017-11-11, 05:58 PM)Michael2014 Wrote:
(2017-11-11, 03:56 PM)Livewire Wrote:
(2017-11-10, 11:40 PM)Michael2014 Wrote:
(2017-11-10, 07:47 PM)Livewire Wrote:
Quote:Specific bits of data are accessed by queries written in a particular interface language, such as SQL. Database optimization involves maximizing the speed and efficiency with which data is retrieved. Database designers, administrators and analysts work together to optimize system performance through diverse methods.

Hi, thanks for the response!
Ive read threads where people have optimized their datebase in admin cp and in messed up their site.

I've always optimized mines nothing happened to my site. :/

What good does it do for your site?

See: https://community.mybb.com/thread-96305-post-704558.html#pid704558


RE: What does "Optimize Databases" do? - Michael2014 - 2017-11-12

(2017-11-11, 11:56 PM)Wage Wrote:
(2017-11-11, 05:58 PM)Michael2014 Wrote:
(2017-11-11, 03:56 PM)Livewire Wrote:
(2017-11-10, 11:40 PM)Michael2014 Wrote: Hi, thanks for the response!
Ive read threads where people have optimized their datebase in admin cp and in messed up their site.

I've always optimized mines nothing happened to my site. :/

What good does it do for your site?

See: https://community.mybb.com/thread-96305-post-704558.html#pid704558

Okay, now that is exactly what I was looking for!