Recent content by insocial

So, just an update. We isolated the test database and viewed the processes active during the delete. There were calls to tables without an index on the where column. By adding these indexes: ALTER TABLE `xf_conversation_master` ADD INDEX ( `last_message_user_id` ); ALTER TABLE...

Thanks for the tip. Since we are removing zero post users, we could comment out xf_post, for example. Since this is the largest table, it would seem that this would speed things up. After doing a lot of experimentation, it doesn't have a big impact on the speed though. In fact, removing all of...

These users do not have any content but I suppose the query has to iterate through all tables that could contain content. I wonder if maybe we could limit that knowing that there isn't data to be removed in these cases. Any other ideas on how to speed this up?

We are in the process of cleaning up our user database. Currently have about 700,000 user accounts. We want to delete around 300,000. The problem is that it takes approximately 20-25 seconds to delete each user. Does anyone know of a way to speed this up or how to figure out why it is taking so...

I can understand that a user might have to enter a few tries to get a large enough city to work, but the result might be worth it in our case. Much easier to search and sort by location. If you are getting the geonames data, then I assume you are also getting the latitude/longitude for the city...

This looks like a great start! Would it be possible to limit the locations that are available to select? Our idea has long been to allow users to select only from the nearest major city. The ultimate goal being to allow users to find others near them. If you allow even the smallest towns, as the...

Will this also cause old links to be rebuilt to use the link proxy?

Great addon. Please consider adding a user option to only include watched threads.

Ok, thanks. The export log shows entries like "data/avatars/s/0/140.jpg => No move" for the avatars that are not being imported. There is about 500 out of 32,000 so not that bad I guess. I did note that using the GD vs imagemagick greatly improved the speed of the export, 17,963.15s vs 741.57s...

After some time I now have a working Export/Import. However, I've noticed an issue with custom avatars. For some users the avatar is not importing correctly. If on vB 3.8 they had a .gif custom avatar, then on the Import they have a .jpg avatar and the image is broken. Any ideas?

Thanks for the info. :)

It's worth the money to avoid the extended downtime. I'm primarily concerned about data integrity after the import. By effort/prep/testing are you implying that it will likely fail out of the box and require code tweaks to get it working?

We are preparing for an import of a vB 3.8.4 forum into XF 1.4.7. 5M posts, 650k members, a lot of PMs. Currently testing the web based importer and it is going to take 24-48 hours total. Maybe a little less if we disable all other mysql activity on the server. My question is, will this importer...

Hi there. Great addon! Thanks for creating it. I'm using it in a widget incorporated into the home page. I noticed that when you initially load the screen that the feed is empty, and then in some milliseconds it gets populated with the current feed. I wondered if there is a way to lose that...

Is there a way to turn off alerts and conversations for group activity?