1

Topic: on type language php

Decided unpretentious  to make on php
Something already works
For example 100000 interposes into the table with one column for 20
Displays approximately for the same time
Task essence in that:
1. That the basis to learn to do (then on the compiled language I will translate)
2. On a web site to have  with minimum expenses and more productive
How much this task actually also is perspective for a society, it would be desirable to learn?

2

Re: on type language php

bas02 wrote:

how much this task actually also is perspective for a society, it would be desirable to learn

It is irrelevant and unpromising

3

Re: on type language php

Isokerf;
Justify

4

Re: on type language php

wrote:

it is passed...
It is irrelevant and unpromising

Really the site on mysql will be more
As mysql it is normal on a separate server which will be periodically
Accordingly the probability that a site will not work increases in 2 times + a hosting with sql more expensively than without it

5

Re: on type language php

;
As you are mistaken;
If you have a source code which reads the data (function with a cycle) you on basis can make super optimized request,
Copying it and to make separate function
Rather than than will write sql then a server it to analyze, something to do not the fact that it correctly and optimally disassembles it and then produces the data, then you receive this data and start over again to cost a cycle, what them somehow to transform
100 % such approach is less effective
I understand that now is 400
But they become as the general-purpose tool
For example try to turn the Swiss knife something -  it turns out it is necessary to use a chisel...
I think you understood

6

Re: on type language php

bas02 wrote:

as mysql it is normal on a separate server which will be periodically

They work as years...

7

Re: on type language php

bas02 wrote:

I understand that now is 400
But they become as the general-purpose tool

key-value Storages considered?

8

Re: on type language php

bas02;
Do mandatory, any DBMS on  while is not present, how much I in course. Same abruptly will be!
And that that we here it here - behind any  in MySQL climb. And here  -  is on the server? So it is exact, a companion the high developer! Well all - here to you and a DBMS at once.
In an any way do. Then on Kickstarter it will be possible even likely !

9

Re: on type language php

Though is not present - stop of feet of feet. .
Similar attempt already has been some years ago fixed in our Galaxy: a DBMS on PHP - it is real!
It is necessary to esteem  - ridiculous)

10

Re: on type language php

on  language? Here: https://github.com/tonsky/datascript

11

Re: on type language php

Isokerf;
And what is it?

12

Re: on type language php

wrote:

it is passed...
They work as years...

Periodically sites hang

13

Re: on type language php

bas02 wrote:

it is passed...
Periodically sites hang

And monitoring tried to use? Suddenly at you the following pattern:
[img=https://docs.newrelic.com/sites/default/files/thumbnails/image/php-apm-app-overview.png]

14

Re: on type language php

That is on MySQL 10 % of time of handling of request are necessary, and the most part is necessary on PHP.
And sites hang because of the curve code on PHP.

15

Re: on type language php

http://rapideuphoria.com/russian/database_r.htm http://rapideuphoria.com/database.htm
http://rapideuphoria.com/russian/cgi_r.htm http://rapideuphoria.com/cgi.htm

16

Re: on type language php

Bothers  if suddenly:
http://rapideuphoria.com/russian/e2c_r.htm http://rapideuphoria.com/e2c.htm

17

Re: on type language php

skyANA wrote:

That is on MySQL 10 % of time of handling of request are necessary, and the most part is necessary on PHP.
And sites hang because of the curve code on PHP.

mysql - one server
php - the second server
On these servers besides your site still there is a heap of other sites and bases
There will be a probability of that that hangup because of someone
About it there is once a year or two times from practice
If at you all on one server that bluntly probability of hangup twice is less

18

Re: on type language php

bas02 wrote:

there will be a probability of that that hangup because of someone

But because of MySQL - in the last queue.
I generally never in life saw  MySQL (very long handling of request by hangup do not consider since it not MySQL it is guilty).

19

Re: on type language php

bas02 wrote:

it is passed...
mysql - one server
php - the second server
On these servers besides your site still there is a heap of other sites and bases
There will be a probability of that that hangup because of someone
About it there is once a year or two times from practice
If at you all on one server that bluntly probability of hangup twice is less

From what it is probability of hangup less, especially when "besides your site still there is a heap of other sites and bases"? smile
On the contrary.
For example handling of the regular expression on one site can is substantial  CPU and all remaining on this "server" should test hangup smile
Well and a picture you saw? At you other metrics? Or at you only assumptions?

20

Re: on type language php

Well, and when that basis will be then

bas02 wrote:

(then to the compiled language I will translate)

It is translated on compiled, it it will be exact better MySql or SqlLite or postgres'a?
If there is a lot of time paternal not to make the basis.... No, the programming language, on it the basis.... And it is even better - the axis, under it language, on it....

bas02 wrote:

justify

What for? If the colleague speaks to the tourist - there do not walk, there a bog. The tourist such - "justify!" - you want, go...... Years a little by the way the paper book was, where explicitly understood as on pluses to write the interpreter simplified SQL. To search for laziness...
And so I will join - not actually.
And reminds trolling,  a little....

21

Re: on type language php

Vladimir Baskakov;
Who told that that about what here is told it should be better mysql
It is a question of that to make basis with minimum, but sufficient
Functional and to be completely independent of suppliers
In some projects
What for to share profit of the clients with suppliers ?

22

Re: on type language php

skyANA wrote:

it is passed...
From what it is probability of hangup less, especially when "besides your site still there is a heap of other sites and bases"? smile
On the contrary.
For example handling of the regular expression on one site can is substantial  CPU and all remaining on this "server" should test hangup smile
Well and a picture you saw? At you other metrics? Or at you only assumptions?

Metrics for a pair of clocks?
It is a question of stable operation for a year

23

Re: on type language php

miksoft wrote:

it is passed...
But because of MySQL - in the last queue.
I generally never in life saw  MySQL (very long handling of request by hangup do not consider since it not MySQL it is guilty).

Did not face about volume that the same request can fulfill for different time?
Can for shares of seconds and can and for some tens seconds?
Probably it depends on loading of a server, a network... But such periodically happens

24

Re: on type language php

And, but dependence from PHP is saved?
Independence - concept relative, me enough already existing units for reading dbf, already existing sqllite extensions.

bas02 wrote:

for example 100000 interposes into the table with one column for 20

And try in , sqlloader th to flood, or in mySql beforehand  request insert - surrenders to me, becomes faster. In SQLite?
Already become CMS and forums on dbf - xml, without MySql. Work.... Somehow.....
Purely - php  the code obviously loses on speed compiled, a cheap hosting hardly to allow to put in  the compiled extensions, and here  or SQLite there already will be, most likely.
To implement syntax with , in and , and to write an engine which though somehow optimizes cycles, let and disgustingly - it is uneasy enough.
Therefore it is personally difficult to me to present the project in which the considered decision will be useful. To make the DB - from the point of view  it is finite abruptly..... But on PHP? But business that master's. It is pleasant - do.....

25

Re: on type language php

bas02 wrote:

it is passed...
Metrics for a pair of clocks?
It is a question of stable operation for a year

That that on a picture time range in the last 3 hours is selected says that metrics in the last 3 hours wanted to look, instead of that they are only in the last 3 hours smile
Personally at you what metrics? Or you do not have metrics, but only the assumption?