Jump to content

Time for an IPS4 performance review/update?


Recommended Posts

  • 4 weeks later...
  • 7 months later...
  • Management
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.

Link to comment
Share on other sites

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. 

Link to comment
Share on other sites

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
Link to comment
Share on other sites

  • Recently Browsing   0 members

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