SQLite vs Excel for STD as database

Channel:
United Kingdom Geb Systems
Subscribers:
567
Published on ● Video Link: https://www.youtube.com/watch?v=yDAVgVCk-D0


Duration: 4:46
318 views
4

I generated 360k orders yesterday and I tested it today using XLS as the database... It did not go well. So I put together a quick test "rig" to see how it would compare against the simple SQLite database. You do not need to guess what the outcome was.

Now... in the long run would I still use Excel as the medium that new data will be imported in bulk via some kind of scheduled task or I use csv file for that? I guess that would depend on how many tables/sheet you have to manage.



Other Videos By Geb Systems


2022-09-18Spirit Hunters: Infinite Horde Gameplay
2022-09-14Discovered that Mailto: can fix my O365 issue
2022-09-07More polished WooCommece Invoice Generator
2022-08-29Nordic Ashes: Survivors of Ragnarok Gameplay
2022-08-20DIY Intranet for WooCommerce Integration
2022-08-18WooCommerce DIY integration?
2022-08-15Suriouc: Suggestions on the roadmap
2022-08-12Suriouc: Excel2Web getting closer
2022-08-06Constructor: Excel to Web & SQL Schema?
2022-07-31Web Interface over Excel file
2022-07-25SQLite vs Excel for STD as database
2022-07-19Smiling Troll Distillery Limited (Incorporated)
2022-07-17DIY Intranet: CSV2SQLITE Tool
2022-07-14Basic DIY Intranet: Simple Barcode Generation Demo
2022-07-12Arduino Mp3 Player... 2nd UPDATE
2022-07-10Basic DIY Intranet: Going deeper
2022-07-09SQL INNER JOIN on two CSV files
2022-07-07Basic DIY Intranet: Read from Excel files
2022-07-05Basic DIY Intranet: Web Server (XAMPP)
2022-07-05Basic DIY Intranet Part 2: Database Connect Function
2022-07-03Din rail for Arduino Projects


Tags:
php
sqlite
excel
benchmark