Data batch check insertion

data batch check and insert, because each record needs to be compared with the data already existing in the database, compare the insertion of OK, compare the generated error messages of non-OK, and export an excel file after all execution.

in the past, la was used to check one by one, but the efficiency is very slow, because every time you insert a piece of data, you have to execute a sql statement to verify it.

then pull out the associated data at one time and verify it in php, filter the data that can be inserted to generate an array, and insert it with insert at one time.

efficiency is fast, but will there be any problems?

Laravel php

Nov.20,2021

The optimization method of

is very common, which reduces the number of interactions between the application and mysql and the number of sql statements. You should know that each interaction and the parsing of each sql statement will cause a certain loss to the performance of mysql to a certain extent. Therefore, this method improves the performance of the mysql system and places the pressure on the specific operation of the application. It is good to improve the system capacity when the amount of data is small and the operation is simple, but it is also necessary to prevent excessive memory consumption when the amount of data is very large and the operation is complex. no, no, no.
you can test the details by yourself. What I said may not be absolutely correct. Testing is necessary, as long as it suits your business and architecture

Previous: When iview DatePicker initially has a default value, the unselectable date set by options does not work.

Next: On the Corialization of functions

Laravel queries all the articles under it through the tag tag.
post table is the article table, the primary key is id tag table is the tag table, the primary key is id post_tag is the intermediate mapping table, and the field is post_id,tag_id now I want to select tag 1 to find out that all the tags and article...

Laravel php

Feb.26,2021
How to catch FatalErrorException exception and return information correctly by lumen
I judge in the render method of Handler that FatalErrorException returns an array when an exception occurs. there are other error messages on the returned array, but should you only return the array when catching an exception? how to solve this sit...

Error exception lumen laravel php

Feb.27,2021
Laravel Package development, how to deal with the many-to-many relationship between Model in a package and Model outside a package
laravel Package development, how to deal with the many-to-many relationship between Model in a package and Model outside the package? for example: for example, we are going to write an awesome Article Package,. This package mainly provides functions ...

Laravel php

Feb.27,2021
The problem of the usage of laravel's model
I think belongsTo or hasMany is usually written in model. What s the use of writing this? The following is the code in someone else s Car model. I think when he used it in the controller, he wrote $car = Car::find ($id) . It doesn t seem to be conve...

Laravel php

Feb.28,2021
Laravel big data exports how to optimize excel
laravel big data export cannot perform how to optimize ...

Laravel php

Feb.28,2021
Laravel deployment multiple projects
suppose: there are two projects, Project An and Project B, and I want Project An and Project B to share the same framework. Is there a way to achieve ...

Laravel php

Feb.28,2021
How to install Laravel? in mac
https: devforgalaxy.github.i. I am here to see the first step alone is off . sudo php -r "readfile( https: getcomposer.org installer );" > composer-setup.php -bash: composer-setup.php: Permission denied ...

Composer laravel php macos macbook

Feb.28,2021
What is the difference between the request parameters obtained by Input:all () in the laravel framework and the native $REQUEST acquisition parameters in php?
what is the difference between the request parameters obtained by Input:all () in the laravel framework and the native $REQUEST acquisition parameters in php? $input = Input:all (); $input = { "P_UserId ": "10 ", "P_OrderId ": "2302722018033018420...

Laravel php

Feb.28,2021
Php recommends developing an interface framework for APP
1. Do you need a framework? the framework loads too many files by default, which hinders performance . two The framework comes with interface verification (to prevent arbitrary calls), version management (APP version upgrade is fast), etc., if there is ...

Mysql codeigniter thinkphp laravel php

Feb.28,2021
Routes defined by Laravel resource can only access index,. The rest of them return 404.
Laravel version5.5, uses php artisan serve to start the metropolis server to confirm that the route has been registered, the result obtained by using php artisan route:list is as follows visit batches and return 200 correctly visit b...

Laravel php

Feb.28,2021
Is it theoretically possible to use cookie/session for user authentication for Laravel front-end and front-end separation projects?
I added withCredentials to my front-end request, even though I deployed the front and back ends separately. assume that the front end is deployed at web.xxx.com and that the back end is deployed at service.xxx.com I define all api as web, so ...

Laravel php

Feb.28,2021
Does PHP have a library that can edit excel files?
by editing a template file such as file.xls, there is a lot of data that needs to be filled in by php, and then other text or tables may have styles, such as red words, large words, table borders, etc. (I have tried to export csv, but feel that this for...

Excel laravel php

Mar.01,2021
How does the laravel excel extension choose a directory path to download files as if it were saved as?
download : ask the boss to answer it! ...

Laravel php

Mar.01,2021
Laravel form validation, how to validate and change (transform) the data?
$validator = Validator::make($request->all(), [ id => required|integer title => required|unique:posts|max:255 , body => required , ]); The requirement is like ...

Php-laravel php-Framework laravel php

Mar.01,2021
On the problem of laravel5.4 form validation in different scenarios
just started to use the laravel framework development, or rookies ~ a lot of do not quite understand, at present to do a function, customized a form verification class file ~ ~ for example, I am now a member module, my member controller can have many way...

Mysql laravel php

Mar.01,2021
When developing Laravel packages, can you use other Laravel packages in one Laravel package?
how do I use a laravel package such as l5-repository ( https: packagist.org package.) when developing a laravel package myself? We can use composer require to come in, but how do we register ServiceProvider in the package? ...

Laravel php

Mar.01,2021
About the problem of uploading pictures on laravel ajax
I use js to assemble the data and then ajax to transmit it to the background. $request- > file () always cannot receive the file, and the file field passed by is always converted into a string [object File] how to solve foreground ajax code onAjax(f...

Ajax laravel php

Mar.01,2021
The result of Mini Program parameter passing back-end is [object Object]
Mini Program post requests that an array of objects is passed in the data. What happened to the [object Object] printed out by the backend? ...

Mini-Program laravel php

Mar.02,2021
Laravel update data automatically inserts blank data
Why do you have to insert a new piece of empty data every time you execute this statement one more empty data at a time. I don t know how to ask for advice ...

Laravel php

Mar.02,2021
How to configure Redis in Homestead?
the configuration of Redis was not found in official document . How should I configure it? add: configure requirepass in the configuration file of Redis, but this Redis is on Homestead, not locally. Because of my unfamiliarity with Homestead, I don ...

Laravel php homestead php-Framework

Mar.02,2021