Comments (7)
ankush
commented on May 24, 2024
1
database storage report > action > optimize table > select doctype ??
from frappe.
niraj2477
commented on May 24, 2024
1
https://www.postgresql.org/docs/current/sql-vacuum.html
We can have something like frappe.db.optimize() maybe to support for both db 🤔
from frappe.
ankush
commented on May 24, 2024
1
Btw OPTIMIZE basically rewrites entire table for InnoDB. Optimize call causes a lot of I/O on large tables. People will spam this everywhere without knowing costs of it. It's simple query, doesn't need any special API IMO.
from frappe.
niraj2477
commented on May 24, 2024
We can optimize both MyISAM and InnoDB tables.
https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html
from frappe.
akhilnarang
commented on May 24, 2024
We can optimize both MyISAM and InnoDB tables.
Yep, had pointed out specifically for MyISAM since the need came about because the storage doesn't get freed up.
Will update title to keep it generic.
from frappe.
niraj2477
commented on May 24, 2024
rewrites entire table for InnoDB
True. Can be just db.sql in that case, will work on it
from frappe.
frappe-pr-bot
commented on May 24, 2024
🎉 This issue has been resolved in version 15.25.0 🎉
The release is available on GitHub release
Your semantic-release bot 📦🚀
from frappe.
Related Issues (20)
- Modal: Double clicking primary button triggers primary action twice HOT 1
- (Minor) frappe.db.delete doesn't seem to trigger hooks but its written in method's docstring HOT 1
- On Leaderboard - Company select field is missing, only on first selected menu. HOT 1
- no bulk edit when workflow active HOT 1
- Show Title of Link in TimeLine
- Contact Details "Vertical" HOT 1
- Contact Details "Vertical" HOT 1
- frappe command to setup ldap
- Workflow permission by user (field value)
- The "Awesome Bar" is not calculating correctly. HOT 1
- !!client_script frappe.listview_settings filter dont work HOT 1
- Showing virtual fields in list view causes an exception
- Unable to Access Server API HOT 1
- "Click here to post bugs and suggestions" when doctype is Beta - always call https://github.com/frappe/{app_name}
- Display JS Not Working For Column Break
- internal Links in print formats
- JS deprecated document.write for loading scripts caused by `defer` missing
- Report view sorting for child table
- Bug in v15.24.1 using command add-to-hosts HOT 3
- Copy to Clipboard for doctype, Error: Mandatory field 'name' is missing
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from frappe.