Jump to content

Recommended Posts

  • 4 weeks later...
Posted
On 6/26/2022 at 11:15 PM, The Old Man said:

I don't know about you, but I'm wondering if it's perhaps overdue that IPS got stuck into a huge performance and speed based review and implement it in the next medium sized update!

Yes, it has been stuck for several years.

  • 7 months later...
Posted

I have been curious if having multiple back end databases would also improve performance? Putting Schema content in to one file and then user added content in another file? 

  • Management
Posted
47 minutes ago, Ocean West said:

I have been curious if having multiple back end databases would also improve performance? Putting Schema content in to one file and then user added content in another file? 

I'm not sure I follow.

Outside of the odd errant query, databases aren't really a bottleneck, especially in terms of page speed.

Posted

I don't know the performance barriers to SQL databases but my thought was more a separation of concerns. Would it be better to have separate DB file for say all marketplace apps? vs modifying core files? I am sure I have database detritus of columns from old stuff that just keeps hanging around. 

Posted

I think he’s asking to have the ability to separate marketplace and possibly pages DBs into a separate MySQL dbs.  That it is perceived as less risk to have them separated… not that it would improve performance. 

Posted (edited)

I would specifically request that optimizations be made to the getItemsWithPermission() function
Seems like all things and kitchen sink at the moment. Perhaps there is opportunity for SQL optimizations here?
Queries relating to this function are currently the slowest on my site. they regularly show in my slow query log.

Edited by SJ77
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...