Jump to content

Featured Replies

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

Any official position?

  • Management

Yes, we're going to look at some of this for v5.

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
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.

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. 

  • Management

What do you mean by "DB file" in this context?

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. 

  • Management

That would probably slow things down as you need to keep multiple DB connections open and less chance of using joins, etc.

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

  • No registered users viewing this page.