Tag: just

Just delete 50.000.000 of rows on a PostgreSQL table and DB still very slow

sorry for my poor english.

I have a postgres DB runing on amazon RDS (db.t3.small), with django as a backend. i have made a mistake and created 50.000.000 rows. when i figure out (because queries on that table where ultra slow) i delete it all. but the queries i make on that table stills super slow. it only have 300 rows now.

i have to clean some cache? i have to wait something? the configuration of the RDS in aws is default.

the engine version of postgres is 12.5, also have postgis installed in it.

i check for vacuum issues and run this command:

SELECT relname AS TableName,n_live_tup AS LiveTuples,n_dead_tup AS DeadTuples,last_autovacuum AS Autovacuum,last_autoanalyze AS Autoanalyze FROM pg_stat_user_tables;

the table with the problem says:

'appointment_timeslot', 1417, 0, datetime.datetime(2021, 7, 21, 18, 13, 8, 193967, tzinfo=<UTC>), datetime.datetime(2021, 7, 21, 18, 13, 30, 551750, tzinfo=<UTC>)

check for indexes that Django creates automaticly on that table and i find 4

[ ('appointment_timeslot_pkey', 'CREATE UNIQUE INDEX appointment_timeslot_pkey ON public.appointment_timeslot USING btree (id)') 'appointment_timeslot_home_visit_id_62df4faf', 'CREATE INDEX appointment_timeslot_home_visit_id_62df4faf ON public.appointment_timeslot USING btree (home_visit_id)') ('appointment_timeslot_office_id_6871b47b', 'CREATE INDEX appointment_timeslot_office_id_6871b47b ON public.appointment_timeslot USING btree (office_id)') ('appointment_timeslot_time_range_id_715578fa', 'CREATE INDEX appointment_timeslot_time_range_id_715578fa ON public.appointment_timeslot USING btree (time_range_id)') ]

Just Artisan – Multi Vendor Marketplace for handmade goods

Why are you selling this site?
I have taken the site as far as I can. It is time to let someone else take it to its potential.

How is it monetized?
Vendor subscriptions and transaction fees.

Does this site come with any social media accounts?
Facebook, Twitter, Pinterest, and Instagram.

How much time does this site take to run?
As much time as you want. From 5 hours per week to as many, as you want to spend on marketing.

*Low Cost Dedicated Server – E3-1240 with /24 IPv4 available – starts at just $80/mo.

Hostpoco.com has been providing quality web hosting solutions to businesses and individuals. If you want to need full authority and extensive control over your business environment and business sites then Low Cost Dedicated Server is the most suitable option for you. Our Low Cost Dedicated Server not only provides full root SSH access but also enables you to host unlimited domains and install the application which you need, you can resell hosting to provide you the convenience and independence of a dedicated server. Apache, PHP, Perl, and MySQL are pre-installed for all dedicated Servers. To facilitate further simpler and quicker administration you can go for cPanel/WHM control panel for your server.

Our goal is to provide outstanding services for the best possible price. To achieve these goals we are constantly innovating and upgrading our services at no additional cost to our customers.

Payment Mode: Paypal, Razorpay, Stripe, Credit Card/Debit card accepted.

==================================
Best Ongoing Offers
==================================
*Dedi Startup: $80 /Monthly
*Dedi Pro: $85 /Monthly
*Dedi Premium: $95 /Monthly
*Dedi Elite: $110 /Monthly

Key Features Of Our Linux Dedicated Server Plans:

– Multiple DC locations available
– Complete Root Access
– Premium Bandwidth
– On-Demand IPMI
– Desired RDNS records for server IP’s
– 4 Free IP Address
– 1Gbps uplink 10 TB traffic included
– 99 % Uptime Guarantee
– 24/7 Live Support
– SSH Access
– 7 Days Money Back Guarantee
– No Setup Fee
– No Term Contracts
– FREE Migrations

Visit now to read more: https://www.hostpoco.com/low-cost-dedicated-server.php

Have any questions?
Do not hesitate to drop us a support email at sales@hostpoco.com OR visit our page to chat with our Live Chat Support.

Calculate Percentage (No reserve Price. You can have this just for $1)

Why are you selling this site?

Need to work on other websites
How is it monetized?
currently its not

Does this site come with any social media accounts?
no

How much time does this site take to run?
you just need to drive traffic to it. No work required

What challenges are there with running this site?
No challenges. You need to bring traffic and earn money through adsense.

Design isn’t just art!

Just thought I'd share my latest medium article on this topic, just because so many people calling themselves web designers AREN'T anything of the sort. Just as so many of the glitzy but ultimately useless "template sites" are filled with broken inaccessible garbage thanks to the same delusional and nonsensical treatment of the subject.

Much less the gullibility of those who think they can magically buy an off the shelf template, cram their content into it, and magically see succcess….

Design isn't just art!

Can I just hold my Spellcasting Focus, instead of a material (with a price) that I own, to cast a spell?

Let’s say that I want to cast Soul Cage. I know that I need the tiny silver cage worth 100gp. Can I just have it attached to my belt and cast the spell using my Spellcasting focus, or do I need to hold specifically the tiny silver cage?

I’m a Hexblade Warlock with a glaive and the Improved Pact Weapon feature, wich makes my summoned glaive my Spellcasting Focus. I wonder if there’s a way to kill an enemy with my glaive then use my reaction to cast Soul Cage.

Source link plugin – show just anchor / link

I implemented a small source link plugin on my WordPress website via the following codes.

Single.php:

                        <?php global $  post, $  pages, $  page;  $  total = count( $  pages ); // Link źródłowy if ( $  total < 2 || $  page === $  total ) :          if ( $  url = get_post_meta( $  post->ID, '_source_link', true ) ) :         $  label = get_post_meta( $  post->ID, '_source_link_label', true );         $  label = $  label ? $  label : $  url;     ?>         <div class="source-link">             <b>Źródło:</b> <a href="<?php echo esc_url( $  url ); ?>" rel="nofollow" target="_blank"><?php                 echo esc_html( $  label ); ?></a>         </div>     <?php endif;  endif;  ?>

Functions.php:

add_action( 'add_meta_boxes', 'wpse_source_link' );   add_action( 'save_post', 'wpse_source_link_save' );   function wpse_source_link() {      add_meta_box(         'source_link',         __( 'Link źródłowy', 'myplugin_textdomain' ),          'wpse_source_meta_box',         'post',         'side'     ); }   function wpse_source_meta_box( $  post ) {      wp_nonce_field( plugin_basename( __FILE__ ), 'myplugin_noncename' );       echo '<label for="source-link">Link</label> ';   echo '<input type="text" id="source-link"" name="source_link" value="'.     get_post_meta( $  post->ID, '_source_link', true ) .'" size="25" />';    echo '<label for="source-link-label">Nazwa strony</label> ';   echo '<input type="text" id="source-link-label"" name="source_link_label" value="'.     get_post_meta( $  post->ID, '_source_link_label', true ) .'" size="25" />'; }   function wpse_source_link_save( $  post_id ) {    if ( defined( 'DOING_AUTOSAVE' ) && DOING_AUTOSAVE )        return;    if ( ! wp_verify_nonce( $  _POST['myplugin_noncename'], plugin_basename( __FILE__ ) ) )       return;     if ( current_user_can( 'edit_post', $  post_id ) ) {        update_post_meta( $  post_id, '_source_link', sanitize_text_field( $  _POST['source_link'] ) );       update_post_meta( $  post_id, '_source_link_label', sanitize_text_field( $  _POST['source_link_label'] ) );     } }

As you can see there are two fields: Link źródłowy (Source link) and Nazwa strony (website name – anchor). However, at this moment this plugin only works, when both fields have some text inside. Is there any way to make it work also with just anchor/link? I mean, if two fields are completed it should show anchor with link, but if just anchor has some text in it, then it should show only anchor. Same goes for link.

Does anyone know how to make it work like that? To be honest I’m a newbie and I have no idea.

Browser loses connectivity to website. Switching browsers helps, but just temporarily [closed]

This problem shows up when I have poor WiFi connectivity, or no WiFi. I’m using my android phone, with chrome browser, to connect to my website (LAMP), and limping along with poor response, but happy and productive. But then I can’t reach the website at all. I can reach other websites but not my website. I’ve tried closing my chrome and reopening it. If I wait several minutes I can usually get back to my website. However, my application is time-critical and this delay is very disruptive. I’ve found that when I can’t get through on chrome, if I immediately switch to the Samsung browser (also chromium-based) I can regain access to the my website right away. Then after several minutes, I might lose access again. I can immediately regain access if I switch back to chrome. So the problem is not chrome itself. Perhaps if I had 2 instances of chrome, say chrome and chrome-beta, I could switch between those successfully. But I haven’t tried that experiment. In long sessions, with very bad connectivity, I have to switch browsers about every 5 minutes.

It seems like the bad connectivity causes Apache to temporarily ignore me. Perhaps some mechanism whereby the socket (or some other intermediate-entity, like a PHP worker) is marked "bad" but not closed. So that intermediate-entity has to timeout before the same browser can connect again. Perhaps by switching browsers, a new intermediate-entity is opened and the old one abandoned. I’m just guessing at a possible mechanism.

I’ve looked at apache error log, apache access log, php error log and php-fpm error log. I don’t see anything that coincides with my connectivity problem. My php max_execution_time is set to 120. I’m not hitting that as far as I can tell.

Can a caster of Dispel Magic just target a specific spell on a creature? [duplicate]

Dispel Magic says (emphasis mine):

Choose one creature, object, or magical effect within range. Any spell of 3rd level or lower on the target ends. For each spell of 4th level or higher on the target, make an ability check using your spellcasting ability. The DC equals 10 + the spell’s level. On a successful check, the spell ends.

At high level play, I’ve found that players often have long-term buff spells in effect (i.e. Heroes Feast, Mindblank, etc.), which are a major factor in them being able to survive.

If one of these characters is affected by a save or suck kind of spell (i.e. Mental Prison, Irresistable Dance, etc.), the need to remove that spell becomes imperative.

With this in mind, can a caster of Dispel Magic target only a negative spell under the assumption that it is a discrete ‘magical effect’ subject to removal? Or must they target the ‘creature’ and risk removing all spells, both positive and negative?

For reference, we see a potentially unique ‘magical effect’ in this question about Yeenoghu’s flail. This effect is similar to a spell in its function (target is affected by the Confusion spell if they fail the save), but has clear differences from a spell because the spell would require Yeenoghu’s concentration and have a different duration. Conversely, this answer suggests that a ‘magical effect’ only applies to things that wholly separated from the creature.