Mellisa

Members
  • Content count

    110
  • Joined

  • Last visited


Mellisa's Activity

  1. Mellisa added a comment on a blog entry: Nexus Support/Shipping on front end   

    Purchases: 0
    Downloads: 12

    i suppose it is now for money :D
  2. Mellisa added a post in a topic: Support for PHP Memcached lib   

    whats the diff?
  3. Mellisa added a record in IP.Board   

    sphinx not obeying "block forums" setting
    I have trash category and i select it in the search settings to block search on such forum.


    Using traditional search it blocks results from trash.
    Using sphinx is does not.

    [size=1]Perhaps this needs another bug report, but would like to know, why indexing process is done only by one query? It takes 10 hours to finish and locks the table totally. Make it to index results every 10000 at a time. Will keep the site running and indexing as well.[/size]
    • 0 replies
    • 0 views
  4. Mellisa added a post in a topic: Google Checkout - Alert Pay - and more   

    7SiN: I was misunderstood here. I was talking about ipb will make 1000 more sales every month just by people who see more gateways being added.

    In all cases i seek alertpay and libertyreserve!
  5. Mellisa added a comment: mysql performance issue   

    hello,

    i once made a ticket it was closed. ipb staff said it is not ipb related issue. nor i guess it is a server issue. might some kind of limitation with mysql and this tweak solved it. now i have to find where it should be made. i suggest do some tests first on both queries on very large boards that have problems (like mine)

    note: that issue is random and not always the first query fails.
  6. Mellisa added a record in IP.Board   

    mysql performance issue
    I've been suffering from mysql performance for long and recently the below query doesn't seem to finish.

    [CODE]
    SELECT p.pid, t.tid, t.last_post, t.topic_firstpost
    FROM ibf_posts p
    LEFT JOIN ibf_topics t ON ( p.topic_id = t.tid )
    WHERE p.author_id =1
    AND p.post_date >879423196
    AND state != 'link'
    AND p.queued =0
    AND t.forum_id
    IN ( 5, 6, 13, 9, 11, 7, 12, 15, 18, 20, 19, 45, 30, 25, 27, 29, 52, 31, 22, 16, 21, 44, 38, 39, 43, 40 )
    AND t.last_post >879423196
    AND t.approved =1
    ORDER BY p.pid DESC
    LIMIT 0 , 1000
    [/CODE]

    i followed the suggestion proposed here: http://stackoverflow.com/questions/2297748/mysql-sorting-results-takes-a-long-time

    so I tried to run the mysql query again

    [CODE]
    SELECT p.pid, t.tid, t.last_post, t.topic_firstpost
    FROM ibf_posts p
    LEFT JOIN ibf_topics t ON ( p.topic_id = t.tid )
    WHERE p.author_id =1
    AND p.post_date >879423196
    AND state != 'link'
    AND p.queued =0
    AND t.forum_id
    IN ( 5, 6, 13, 9, 11, 7, 12, 15, 18, 20, 19, 45, 30, 25, 27, 29, 52, 31, 22, 16, 21, 44, 38, 39, 43, 40 )
    AND t.last_post >879423196
    AND t.approved =1
    ORDER BY p.author_id DESC, p.pid DESC
    LIMIT 0 , 1000
    [/CODE]

    finished in 4 seconds, where it used to hang on for ever. I tried several ids to avoid mysql caching and this slight modification seem to did the trick.
    • 0 replies
    • 0 views
  7. Mellisa added a post in a topic: Google Checkout - Alert Pay - and more   

    i guess the following MUST be implemented:
    alertpay
    Liberty Reserve
    moneybookers

    but mainly alertpay it became very popular after paypal started to scam most users and ended many doors for families to life.
  8. Mellisa added a post in a topic: Two features have to be brought back   

    i agree with 1 only
  9. Mellisa added a post in a topic: VBulletin 3.8 to Invision Software   

    if u want help to convert your site let me know. i have converted from the past as well and i managed to make everything work perfectly.

    ipb is a great choice!
  10. Mellisa added a post in a topic: money gateways missing!   

    bump!!

    alertpay all the way
  11. Mellisa added a post in a topic: Google Checkout - Alert Pay - and more   

    i agree, nexus for me is useless since it only supports paypal. what about alertpay? moneybookers? Liberty Reserve!?
    it takes 1 week of work and in return you have 1000 extra sales every month
  12. Mellisa added a post in a topic: Switch from Rich Text to Regular Editor   

    not that i hate WYSIWYG but as a webmaster i'd rather use the old bbcode way
  13. Mellisa added a post in a topic: Switch from Rich Text to Regular Editor   



    ipb are doing great, but they can tweak this issue only. not to gray out the options! i know ipb tries its best to be different. but its not always what people want. just saying..
  14. Mellisa added a post in a topic: Switch from Rich Text to Regular Editor   

    just do like vb, toggle between the old and new way
  15. Mellisa added a post in a topic: What do you think of 3.2?   

    sadly there aren't real skins around that stands among the rest. i would really like to see a skin that makes me stop for a moment to explore it.

    sadly.. this never happen

About Me

Status Feed