Join devRant
Do all the things like
++ or -- rants, post your own rants, comment on others' rants and build your customized dev avatar
Sign Up
Pipeless API
From the creators of devRant, Pipeless lets you power real-time personalized recommendations and activity feeds using a simple API
Learn More
-
Oh wow, my friend spent the last 3 years studying databases to become a good db engineer, and your company just straight up dumps the task on a developer.
My suggestion is to refactor the tables into smaller ones, and if your sql supports it, save some search queries so they dont always get implicitly called -
What is the DB system?
SQL Server has built in scheduling for maintenance. @iAmNaN will have to speak to Oracle. I’m guessing they don’t have a DBA and there is no telling what is wrong with the system because of other programmers doing DBA “fixes”. -
@MalekL which DBMS?
-
@iAmNaN Microsoft sql server management studio
-
Leverage the built in Server Agent to schedule jobs/scripts. https://docs.microsoft.com/en-us/...
As you are an “Accidental DBA” look into Ola’s prebuilt stuff. https://ola.hallengren.com It isn’t perfect for all cases but if the DB was Dev built you probably aren’t using advance stuff like “clustered column store”.
Google I try to love you and use your messengers but you make it difficult.
I started working my new job as a programmer(c#, java, etc.) in a very good programming company.
My first task was to optimise their DB. The DB has indexes and around 3mil rows. The db is slowwww as fuck.
So i made a windows service that reorganises indexes (Depending on blank pages and fragmentation of the index) in DB each week on time.
But as soon as new rows start to come in, the fragmentation of the indexes just sky rocket.
I tried with changing idexes so there will accually be onli indexes we need.
Can anyone help me how can i fix fragmentation problem so the select querries will be much faster.
Sorry if I don't know the solution, I'm new at this task.
Thank you!
question
fragmentation