Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Thursday 3:36 am
Add a reply View Replies (1)

Resolved table partitioning

  1. dr.sus
    dr.sus
  2. General
  3. Monday, October 12 2015, 07:41 AM
Hi,

I was wondering whether it would be possible to partition the profile table (I think it is jsn_fields, right?) to speed up sql queries.
Currently, this table contains more than 30 entries and several entries are of select type that, in fact, query external tables with several thousand entries in each. It works fine on desktops, but is sluggish on cell phones.

Is partitioning possible with this table and will it, in fact, speed things up here?

Thanks.
Accepted Answer
admin
admin Accepted Answer
Admin
Hi,
#__jsn_fields contain fields configuration, this is a small table, not needed partitioning.

It works fine on desktops, but is sluggish on cell phones.
This is impossible, queries are server side, and the speed does not depend from the client. I think this is a problem of your template (probably some javascript function)
  1. more than a month ago
  2. General
  3. # Permalink
Responses (1)
dr.sus
dr.sus Accepted Answer
Thanks,

I know that some browser plugins can do that (Skype Click-to-Call had a disastrous effect until I figured it out), but haven't identified a problem with the template so far.
  1. more than a month ago
  2. General
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.