performance tuning – Typical time for JDBC import in a Postgresql Database

I need to import data from 70 XML files into a Database.

In the past I converted the XML files with a XSLT into SQL INSERT statements and imported them with psql. This had some limitations (error handling) but was quite fast.

Now I wrote a Java program to import the data. I imported 327828 rows in 70 transactions. PgAdmin4 reports after the import, that the database size is 210 MB and the XML data was 250 MB.

But the whole import took over 5 hours. This seems very slow to me. I do not understand how it is possible to spend more than 5 hours on 210 MB data. But I do not have any empirical values either.

How can I find out, if the time, the import took, is the normal behavior for a JDBC import? Is it possible to profile the import either on the database side or the client side to find any bottlenecks? Is it possible to do some kind of speed test to qualify my database setup?

germany – Hotel room was problematic – what’s a typical compensation?

I recently stayed at a hotel in Munich for six days. For three of these days, I couldn’t connect to the Internet (they had this problem with their system where you’d get disconnected about 30 seconds after you connected). The room also had a foul smell which, as it got stronger, I traced to the bathroom drain; I was moved out of my room into another room, which was smaller, plus I had to move myself. I’ll also mention that I had asked them for cables to connect my laptop to the monitor and the room, and they didn’t have those.

It’s not a fancy hotel, but not a cheap hostel either. The nightly price was 91 EUR, including a very nice breakfast.

When I checked out, I complained about the first two problems – although perhaps not very assertively. What I was offered was a discount equivalent to the price of a soft drink I had taken from the mini-bar. Since I was in a hurry to catch a train, I did not argue – but I do feel I got short-changed and I should have demanded more; say, one of the days off.

My question is: Is there a customary rate or level of compensation in such cases? And if so, is it at the level of a mini-bar drink, a meal at the hotel restaurant, a free night’s stay, or more?

I’ll mention that the lack of Internet access was an issue for me, since I was attending a conference and need to access resources on-line before and after each day.

user behavior – What is the typical ratio of downloads to sign ups for B2C product apps eg A typical fitness/health app?

I have a health app where the user sign up is quite straightforward(at least in my eyes). It goes as follows –

  1. Screen 1 – enter email id, password
  2. Screen 2 – enter verification code sent on email
  3. Screen 3 – enter Name, gender

Currently the average ratio of downloads to sign ups has been around 65% only. So around 35% of the people who download don’t go through sign up process at all. Is this normal for a typical b2c app like ours?
What can I do to improve this?

ranking – What are typical key performance indicators (KPIs) for a marketing agency working on SEO?

When it comes to marketing agencies, there are some common KPI’s that you see on proposals. Generally, they lean less toward technical SEO and more into the content territory; that means anything from keyword rankings to social media success. (Social media management is obviously a different beast than SEO, but lines blur a bit when we’re talking digital marketing in general.)

Here’s a list that isn’t exhaustive but something you can expect to see or request:

  1. Keyword rankings. This will involve content optimization, keyword research, and other activities that will result in tracking metrics for keyword-based rankings in the SERPs.

  2. Organic traffic numbers.

  3. Inbound link metrics. While the agency certainly should not engage in black hat backlink acquisition tactics, they should be able to come up with a good link building campaign for you that will naturally build off your content.

  4. Due to #3 and #5 below, referral traffic numbers can also be a KPI.

  5. Local SEO metrics such as Google My Business and Bing Places data, including how many times people have engaged with those profiles. You can also measure call metrics – if you set up a dedicated phone number for directories like GMB and track it with a service like DialogTech.

  6. Conversions that can be traced to organic or referral traffic. (Just make sure it’s referrals that arrived as part of link building campaigns or other SEO activity.)

Now, if the marketing agency has SEO engineers, we will be talking a different set of KPI’s: improved indexation, decreased 404’s and broken links, decreased number of issues in Google Search Console and Bing Webmaster Tools as well as in SEO software reports like Moz or Screaming Frog… These should be in addition to the content SEO KPI’s listed above, because ultimately, you’re looking for higher positions and better representation in SERPs, and more qualified traffic.

malware – Typical risky connection count from firewall

So, I have MaCafee’s suite of products on my computer and obviously, working from home has caused me to work a lot more using my home computer. Recently, I noticed that my number of risky connections blocked has increased from 0 a month gradually to 1k and now it’s 2k per month. I looked up the whois for those IP addresses and they look like some has or amazon or something like that. Is that an indication that I have been infected with some kind of bot network malware? Or am I freaking out prematurely?

plotting – How to use StreamPlot to plot the typical solution in this directional field? I show u how I wrote the code

How can I plot the typical solution in this directional field using StreamPlot?

The equation is:

f(x_, y_) := y - y^3
p1 = StreamPlot({1, f(x, y)}, {x, -3, 3}, {y, -3, 3}, Frame -> False, 
  Axes -> True, AspectRatio -> 1/GoldenRatio, 
  AxesLabel -> {"x", "y(x)"}, BaseStyle -> 12, 
  StreamPoints -> {{{{-1, 0}, Red}, Automatic}})

I want to plot the typical solution, for example, when -1<y<0 and y<-1.

Is this typical of the way racist right wingers react, and why the Black Lives Matter movement is necessary?

If this were typical, it wouldn’t be a news story and it wouldn’t have generated a very strong response from NASCAR officials.  

“NASCAR, to its credit, not only brought the news to light, but announced, in the strongest possible terms, its intention to root out whoever hung the noose. “

5 Typical Delusions Regarding The Foreign Exchange Market In 2020 – General Forex Questions & Help

Hey, everyone. A new BLAST has arrived.

So, welcome to today’s topic which is DEFINITELY gonna shed a light on few misconceptions that many people have concerning the Foreign exchange market. It is no doubt that Forex trading is at the highest peak of popularity. People are continuously choosing online trading as a decent and passive profession.

But there are some people in our society who have gained several misconceptions about the FX market on their minds.

But wait — there’s more.

They also encourage other people to believe in their misconceptions regarding the FX market. Therefore, we have to stop this misconception from spreading, together obviously.

So, today I’ll be sharing 6 misconceptions that most people have concerning the FX market.

Let’s rock and roll!

1. FX trading is easy as water

Trading currencies shouldn’t be that difficult, right? Well, it isn’t rocket science, but it’s not really safe to say that it’s “easy”.

Everyone, or at least everyone except professional traders, says that you only need to read a book or two about trading, set up a brokerage account, and you can jump right to making profits in the Forex market.

Deep down you know it’s not true!

Well, sorry to disappoint you, but understanding the trading method isn’t a cup of tea, and if you’re in for a quick turnover, you’re in for a rude awakening.

Understanding Forex trading takes a massive amount of education regarding the market, strategies, risk management, active Forex trading times, technologies and tools, and Forex market jargon.

Besides, you’ll also have to acquire a few years of experience to be able to place winning trades that will bring you a considerable profit. So, if you are a beginner, spend some time getting educated on everything related to the market and trading currencies.

2. Trading demands a Degree in Economics.

As mentioned earlier in the topic, understanding how to trade Forex is anything but easy. Yet, on the flip note, you also don’t need to have a degree that says you are an economics wizard to understand how trading currencies work.

Now, there’s no doubt that the more you know about world economics and economic concepts, the easier it’s going to be to trade foreign currencies.
Yet, it isn’t an imperative factor that will decide whether or not you can be a trader. In fact, many Forex traders come from various academic backgrounds, not only economics.

Yet, to be a successful trader, you’ll need to have a good head for numbers, an intuition to help you estimate where is the market heading, and the ability to react and make critical financial decisions depending on the market-moving events.

3. You don’t need to start with a demo trading account

Like I’ve mentioned earlier, you’re in for a rude awakening if you think you can start trading and make profits immediately as a beginner. Even after you learn the basics of the Forex market and trading, you still need to test your trading skills out before you jump into the market.

Or, at least that’s what you should do if you don’t want to lose money. Understand that learning about Forex is one thing, actually trading on the market is an entirely different thing.

And, what better way to learn how to trade by actually applying everything that you have learned than by using a demo trading account? Plus, you also don’t have to worry about losing money.

Take demo trading as an indicator of your trading skills. You’ll avoid putting your capital at risk, familiarize yourself with the trading platform and Foreign exchange broker, and learn a thing or two about the psychology of trading, meaning that you’ll learn how to manage your emotions when trading.

4. Forex trading makes you rich overnight

This misconception about Forex trading is entirely the result of a little bit of false advertising.

It’s a familiar story and it usually goes like this!

Who doesn’t want to get rich overnight or with little effort? So, this “get rich quick” advertising line has brought many people into the arena who are looking for easy or rapid returns.

Unfortunately, this may not be entirely true, or at least it is a quite rare scenario.
Building wealth with trading takes patience as for the average trader, it’s rarely an easy road to riches but instead can be a rocky highway that can also involve losses and potential penury.

You’ll have to trade consistently, avoiding the gambling-throw-it-all-at-a couple-trades approach. Over time, as your trading skills improve, so will your trading decisions and your returns. But, once again, it all takes time to happen.

5. Forex is an unregulated market

Another misconception about the Forex market is that there is no authority out there to say what is right and what is not correct to happen during trades.
Picture this!

Now, technically, the Forex market is one of the biggest and most liquid decentralized markets in the world, meaning that there’s no single global body to police this market.

However, read that again, no SINGLE global body because some market regulators are covering the jurisdictions where most of the world’s Forex brokerage businesses are located.

For example, in Australia, you’ll find Forex brokers regulated by ASIC. In the US, brokers are regulated by the CFCT regulator, while in the UK, they are regulated by FCA.
These regulators are essential to make the market safe for traders because there are massive amounts of money passing the market every day, which makes it very attractive for all sorts of scammers and white-collar criminals.

So, these regulators ensure that those qualified to do Forex brokerage are legit and trust-worthy.

Thus, it is imperative when you’re choosing a broker to check whether or not it is licensed by the Forex market regulator in your location.
In the end, there are a lot of misconceptions that exits even today regarding the Forex market.

As a result, many people are unknowingly joining the FX market for earning easy money and facing losses due to the lack of knowledge regarding the FX market.

So, this needs to be stopped, we all need to be aware of that sort of people who are spreading the delusions.


Do you have typical research methods that you always use when starting a new project, regardless if the project is large or small?

Do you have typical research methods that you always use when starting a new project, regardless if the project is large or small? Or is always different for each project? So for example, do you always use competitive analysis?

Is it typical for there to be no real design prior to someone being assigned a task?

I’m a junior engineer, but I’ve worked at two companies now. In both cases I’ve found that I and my colleagues are assigned tasks with no thought put into the design before I’m told to do it.

Typically I spend about 90% of my time writing down on paper how I’m going to do the task, then the code sort of writes itself in maybe a day, sometimes two if I run into difficulties with an API.

Is there something strange about this picture? Is the design supposed to be the work? I don’t really begrudge it, I quite like the designing of things.

But it seems to me it would be more productive to together as a team determine the design of everything to be done, and then everyone can go away and do it pretty quickly, this would put everyone on the wavelength, and so there would be less instances of interfaces not being as you’d like. I feel that once the design is done, the coding is essentially a series of ‘write a function which takes in X and does Y’, which anyone can easily do except perhaps in the case of some complex algorithm being required.

I am thinking of asking my team if we could try designing things up front, before assigning the work. But I am not sure if they will be up for this, or if it’s a ridiculous idea and that’s why I’ve not seen anyone do it.