I will create a business page on Facebook and SEO optimize it. for $5

I will create a business page on Facebook and SEO optimize it.

Hi, There! I will create aFacebook Business Page to help grow your business and brand your company or

yourself.Impress your audienceand customers with an elegant, sophisticated, and Professional Facebook

business page to gain more publicity, coverage, exposure, and conversion get

more traffic on a website. What’s in my Service :

  • I Will create and set up your Business Page.
  • I will Design excellent profile photos and Cover.
  • I will Do SEO.
  • I Will Do Marketing.
  • I will add Auto Boot Reply Service.
  • I will Add detail of your business.
  • Call to action buttons.
  • Linking of other social platforms Instagram, Twitter, Youtube, etc., with Facebook page.

Why Choose my Gig?

  • Professional Digital Marketer.
  • First Delivery According to Your time frame.
  • Instant reply and Friendly Communication.
  • Free Responsive Support Anytime!
  • Will Provide Work Screenshot of Business Page.
  • 100% money back if you don’t like the job.

Note: Creating a Facebook page may require a lot of information from the buyer, such as personal information, businessinformation, social media links.


wordpress – Google Optimize for A/B test: Trying to edit existing HTML but says it’s over the limit even when I test deleting some of it?

I am trying to set up an A/B test of a company’s website for my project. There are certain changes I’d like to make such as changing the ‘favourites’ products on the home page to one with the top selling products which I was trying to do by substituting the existing code simply with the top selling products instead (i.e. their jpg, their links, their names etc).

However I found that when making ANY change (by selecting the element and clicking ‘edit HTML’), even testing it by deleting one character from the original code, that it then pops up with this error notification saying that it’s over the word limit. Even when I put the character back for example, the error message is still there. And it will say weirdly that it is quite a lot of the word limit even though it’s basically the original code! I then have to click cancel every time.

Please see the attached photo for reference (where I deleted one character from the original code to demonstrate how any editing (even deletion of original working code) then comes up with the error that the html is over the limit).

View post on imgur.com

Thanks in advance!

duplicate content – How to optimize SEO for reddit-like sites with many of ouf outgoing links and “copy pastes”

Reddit is quite popular and generates a lot of traffic. However, they must have invented some interesting strategies how to deal with SEO issues.

I mean they have two SEO antipatterns as features.

  • Tonns of outgoing links
  • A lot of Copy & Paste stuff

How do they perform well? Is it only their gravity (and SEO is just as is). Does the amount of unique content (Like comments generated by users) outweigh the rest?
Or any other relevant strategies they or similar sites use?

Is this correct method to optimize local seo?

It’s a local restaurant and I need it to narrow down to city-only search results.

So instead of targeting keywords like "best Asian restaurants" Do I need to use keyword + target city like "best asian restaurants in wellington" like this every time?

mysql – Unknown column in ‘GENERATED ALWAYS’ when doing optimize table

Here is what is discernable from the messages you gave

db.some_table_name_here | optimize | note |
Table does not support optimize, doing recreate + analyze instead

This is perfectly OK. This tells me that the table uses the InnoDB storage engine. This exact message comes out when doing OPTIMIZE TABLE against an InnoDB table.

In other words, doing OPTIMIZE TABLE mytable is implemented in InnoDB something like this

CREATE TABLE mynewtable LIKE mytable;
INSERT INTO mynewtable SELECT * FROM mytable;
DROP TABLE mytable;
RENAME TABLE mynewtable TO mytable;
ANALYZE TABLE mynewtable;

I have discussed this before in the DBA StackExchange

db.some_table_name_here | optimize | error |
Unknown column '`db`.`t`.`total_area`' in 'GENERATED ALWAYS'

This tells me that db.some_table_name_here has system versioning integrated. The MariaDB Documentation has a Section on it

The CREATE TABLE syntax has been extended to permit creating a system-versioned table. To be system-versioned, according to SQL:2011,
a table must have two generated columns, a period, and a special table
option clause:

   x INT,
   PERIOD FOR SYSTEM_TIME(start_timestamp, end_timestamp)

In MariaDB one can also use a simplified syntax:

   x INT

In the latter case no extra columns will be created and they won’t clutter the output of, say, SELECT * FROM t. The versioning
information will still be stored, and it can be accessed via the
pseudo-columns ROW_START and ROW_END:


System Versioning was introduced in MariaDB 10.3. You should check the release notes on MariaDB 10.4 and 10.5 and see if you needed to do special upgrading of system versioned tables.

Until you figure out the proper way to upgrade system versioned tables, you may have to do the optimize table manually as I mentioned before.

Try this:

USE db
CREATE TABLE some_new_table_name_here LIKE some_table_name_here;
INSERT INTO some_new_table_name_here SELECT * FROM some_table_name_here;
DROP TABLE some_table_name_here;
RENAME TABLE some_new_table_name_here TO some_table_name_here;
ANALYZE TABLE some_new_table_name_here ;

You still need to look up release notes anyway if you are using system versioned tables.

Look carefully

1 column: `calcOne` float GENERATED ALWAYS AS (if(`total_area` = 0,0,if(`square_meter_price` = 0,0,round(((`price` - `auction`) / `total_area` / `square_meter_price` - 1) * 100,2)))) STORED

2 column: `calcTwo` float GENERATED ALWAYS AS (if(`total_area` = 0,0,if(`square_meter_price_analog` = 0,0,round(((`price` - `auction`) / `total_area` / `square_meter_price_analog` - 1) * 100,2)))) STORED

It is complaining about total_area. Is this column missing from the table ? If it is missing, then add the column back and try again.

dnd 5e – How to optimize an ‘arcane archer’-ish half-elf sorcerer?

Sorcerer has very little to offer an Arcane Archer-type build, with the exception of the Elemental Affinity feature from the Draconic Bloodline origin. Combined with Elemental Weapon, this allows you to add your Cha modifier as elemental damage to every shot you fire from your crossbow. The problem here is that Elemental Weapon is restricted to the Paladin class only.

So you have 3 options, explained below. Regardless of which you take, you’ll be focussing on Cha and Dex, with Con as a secondary as usual. So you’ll want to spend your 27 points in the 15,15,15,8,8,8 pattern. Then Half-Elf brings you up to 17 Cha, 16 Dex, 16 Con very neatly. Each build gets you 5 ability score increases over your career. You’ll want to use these to bring Cha and Dex up to 20 and take Crossbow Expert so that you can dual-wield hand crossbows.

Option 1 is to take at least 9 levels of Paladin so you can cast Elemental Weapon. Then you’ll want to bring Sorcerer up to 8 and Paladin up to 12 so you don’t lose ability score increases. This isn’t a terrible idea, as many of the Paladin’s (X)ing Smite spells work with ranged attacks, making a pretty reasonable Arcane Archer. With the Oath of Devotion’s Sacred Weapon ability, you could also add your Cha modifier to your attack rolls. That said, many of the Paladin’s class features don’t work with ranged attacks, and it’s not exactly an Arcane Archer anyway. Also, you’ll have to have Str 13 to multiclass Paladin; so your starting ability scores will be 15,15,13,12,8,8 with Half-Elf making it 17 Cha, 16 Dex, 13 Str, 13 Con. (You only lose out on Con, so it’s not too bad.) The main thing this option gets you that the other 2 don’t is the cool Smite spells that add damage and additional effects to your crossbow attacks, just like an Arcane Archer.

Option 2 is to take 6 levels of Lore Bard for Additional Magical Secrets, which you can use to gain access to Elemental Weapon. You could use the other magical secret to get Branding Smite for that Arcane Archer flavour. Then, you’ll want to take 5 levels in a martial class for Extra Attack; I’d strongly recommend Fighter, so that you can take Fighter 6 and not lose an ability score increase. Once you’re Sorcerer 6/Bard 6/Fighter 6, take 2 more levels in whichever of these 3 classes you like to get your last ability score increase. This option is the least focussed, but you get the Archery fighting style and Improved Critical for your crossbow, so it’s got a slight edge with the crossbow you’re looking to optimize. This can also get you Arcane Archer-ing the fastest, since your combo comes into play at level 12.

The final option is to take 10 levels of Valor Bard, and use Magical Secrets to get Elemental Weapon. The other magical secret could be used for Banishing Smite, Branding Smite, or Staggering Smite for more Arcane Archer flavour. While this doesn’t sound as good as Lore Bard, you get Extra Attack for free along the way. Then you should probably take Sorcerer up to 8 and Bard up to 12 to keep all your ability score increases. This option gets you the most powerful spellcasting of all of them, but you don’t get the Archery fighting style.

I will create, fix and optimize an eye catching facebook business page professionally for $5

I will create, fix and optimize an eye catching facebook business page professionally

About this Gig Hi, There is a professional Facebook business page creator and problem fixer and I am here to provide you my impressive services with 100% satisfaction reliability. So don’t miss the chance & catch it now. My best services:

  • Create Facebook page
  • Design outstanding cover photo
  • Setup Profile and Facebook Business Page
  • Fix Facebook Page Issues
  • Setup template according to business
  • Add details of your services, Business
  • Add group & linking to the page
  • Add supported social media Tab
  • Add website, contact info, Location map
  • Setup Shop Now button
  • Fully SEO friendly optimize
  • Tab Setup
  • Scheduling Platforms
  • Add auto reply service

Why me?

  • My packages always include optimizing your page to match your business.
  • 100% customer satisfaction.
  • Money-back guarantee.
  • Supporting the customers at any time
  • Quick delivery with quality service
  • Friendly communication
  • Provide reports & screenshots

Hire Me! And grow your business faster… NOTE: Buyer may need to share their personal or business information, location & social media links, E-mail contact info.


python – How can I optimize and make this code more professional?

It’s generally a very bad idea to put credentials in a program. That’s
a bigger topic, and the best approach will vary depending on your situation.
But you should address this problem.

When naming things, let ordinary English usage guide you: plural for
collections (lists, tuples, dicts, etc) and singular for individual values. For
example, use files and file (or even just f if the context is clear), not
files and Files.

Let your code breathe by putting spaces around operators and related items
(equal signs, commas, etc). It helps with readability and often editability
(latter can depend on the editor). Search for PEP8 if you want more details on
recommended naming and layout practices (PEP8 is not gospel, but it is a good
starting point).

It’s often a good idea to group similar data into collections: for example,
a tuple/list/dict of shares rather than sharename, sharename2, sharename3.

When you see repetition in your code, get rid of it. It’s as simple as that.
Usually, you can do this by writing a function to generalize the behavior: for
example, a function taking a share and returning a count. In your specific,
case the grouping of the shares in a collection provides a more direct route:
kill the repetition via a loop over that collection. And since the logic inside
the loop is just counting, you can stick the whole thing in a single sum()
expression (this works because bool is a subclass of int).

shares = (

ext = '.plot'

totalfiles = sum(
    for share in shares
    for _, _, files in os.walk(share)
    for f in files

You asked about making the script less hardcoded. The most natural
way to do that is via command-line arguments and the argparse module.
That’s a bigger topic, but the basic idea is that the share paths and the extension
(.plot) should be variable parameters with default values. Run the script
without arguments, and it will do the default thing. Run it with arguments
and/or options, and it will use different parameters. That’s the time-tested
way to go with scripts like this, and the internet is full of examples
illustrating how to set up argparse.

web applications – How to optimize the request time for large data response?

I have created a dashboard for rendering a list of clients into a DataTable. Below shown is the data model structure:

When I had a few records in the clients schema, let’s say a thousand rows, the request time was fairly okay. It would take around of 4-5 seconds for the whole trip, from requesting to processing at backend to sending response with data and rendering it to frontend. Once the data reached to 10,000+ rows, the time it’s taking is too much. Now it takes anywhere near 17 seconds or sometimes even more. I’m using Laravel, the Eloquent ORM of this framework brings the data from the related tables (which is highly useful) but as the data is growing it’s increasing the requesting time. My question is what could be a better approach to minimize the request time? How can I decrease the time it takes to request??

query performance – Is there any way I can optimize this merge ranges function?

I have this this function which takes in an array of tsranges, and convert them into one array with tsranges, where each range contains all overlapping ranges from the input.


create or replace function range_arr_merge(arr tsrange()) returns tsrange()
  language plpgsql
 cluster_array tsrange(); 
 value tsrange;
 intermediate_cluster_range tsrange;
 counter integer := 0;
    if array_length(cluster_array,1) = 0 then
     raise notice 'first iteration';
     cluster_array :=  array_append(cluster_array,value);
     counter := counter + 1;    
    end if;
    -- Check if current tsrange and recorded tsrange have points in common
    if value && cluster_array(counter) OR lower(value) = upper(cluster_array(counter)) then 
      intermediate_cluster_range := tsrange(lower(cluster_array(counter)), upper(value));
      cluster_array(counter) := intermediate_cluster_range;
        cluster_array :=  array_append(cluster_array,value);
        counter := counter + 1; 
    end if; 

  return cluster_array;

The problem with this function is that this is slow, it takes me 5 minutes to run this on my full dataset, and that is not optimal.

Is there any way I can optimize this?