Jump to content

Recommended Posts

Posted

Hey guys, 

 

I am wondering if there will be any noticable performance improvement with the help of SQL database indexing. I know that smaller databases do not fully benefit from indexation, but I am curious if any of our devs have tried indexing specific columns to achieve better performance. 

 

Thanks in advance

Posted (edited)

It matters more when it's about Microsoft SQL. You really need a good plan for it - but it's duuper simple.

Edited by Trance

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Posts

    • thanks to ignorant people like you, maxcheaters is the way it is.  
    • You always find a way to lower the bar. Consistency matters. I admire your dedication to being completely unaware of how little you matter.     at least you are not entirely useless you can always serve as a bad example
    • hahahahahahahahahahahaha this says more about MaxCheaters than about me xD
    • I already finished my panel for change name and gender, anyway need restart, im used schema  $stmt = $conn->prepare("EXEC lin_ChangeCharacterName2 ?, ?, ?"); for change name... also for change gender i used if ($race == 5) // Kamael race ID; modify this value as per your database { $error = "Gender change is not allowed for Kamael race characters."; } else { $stmt = $conn->prepare(" UPDATE user_data SET gender = ?, face_index = 0, hair_shape_index = 0, hair_color_index = 0 WHERE char_id = ? AND account_name = ? "); Sorry no idea how to add cached update in myext64 about, not have any  solution for this yet compatible to myext64 code. This is my panel make in php http://177.73.143.43:8080/account/ Cool panel for me, without experience in any code. Without help from any people here 🙄
    • Базы данных от прямых источников!                                  Холодка                 Реги                 Депы                 Богатые физики                                  Много актуальных гео!                 Замена брака!                 Гарант+                                  Контакты                 ТГ - @yashkatsigun    
×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock