Skip to main content
Software Recommendations

Return to Answer

added 124 characters in body
Source Link
cybernard
cybernard
  • 1.7k
  • 9
  • 13

At least for the CSV files I would suggest importing all of those into a sql database such as mariadb(formerly mysql).

select * from table
where (condition1 > 5) and (condition1 <10 ) and
(condition2 > 100) and (condition2 <1000 )
(condition3 > 5) and (condition3 <10 )

Writing these out graphically can be helped by many web based tools like phpmyadmin or adminer.

You can even create indexes for columns that are slow to query. Many more optimization exist if you are will to learn them.

LibreOffice has librebase built-in and Microsoft Office has MS Access built-in

At least for the CSV files I would suggest importing all of those into a sql database such as mariadb(formerly mysql).

select * from table
where (condition1 > 5) and (condition1 <10 ) and
(condition2 > 100) and (condition2 <1000 )
(condition3 > 5) and (condition3 <10 )

Writing these out graphically can be helped by many web based tools like phpmyadmin or adminer.

You can even create indexes for columns that are slow to query. Many more optimization exist if you are will to learn them.

At least for the CSV files I would suggest importing all of those into a sql database such as mariadb(formerly mysql).

select * from table
where (condition1 > 5) and (condition1 <10 ) and
(condition2 > 100) and (condition2 <1000 )
(condition3 > 5) and (condition3 <10 )

Writing these out graphically can be helped by many web based tools like phpmyadmin or adminer.

You can even create indexes for columns that are slow to query. Many more optimization exist if you are will to learn them.

LibreOffice has librebase built-in and Microsoft Office has MS Access built-in

added 81 characters in body
Source Link
cybernard
cybernard
  • 1.7k
  • 9
  • 13

At least for the CSV files I would suggest importing all of those into a sql database such as mariadb(formerly mysql).

select * from table
where (condition1 > 5) and (condition1 <10 ) and
(condition2 > 100) and (condition2 <1000 )
(condition3 > 5) and (condition3 <10 )

Writing these out graphically can be helped by many web based tools like phpmyadminphpmyadmin or admineradminer.

You can even create indexes for columns that are slow to query. Many more optimization exist if you are will to learn them.

At least for the CSV files I would suggest importing all of those into a sql database such as mariadb(formerly mysql).

select * from table
where (condition1 > 5) and (condition1 <10 ) and
(condition2 > 100) and (condition2 <1000 )
(condition3 > 5) and (condition3 <10 )

Writing these out graphically can be helped by many web based tools like phpmyadmin or adminer.

You can even create indexes for columns that are slow to query. Many more optimization exist if you are will to learn them.

At least for the CSV files I would suggest importing all of those into a sql database such as mariadb(formerly mysql).

select * from table
where (condition1 > 5) and (condition1 <10 ) and
(condition2 > 100) and (condition2 <1000 )
(condition3 > 5) and (condition3 <10 )

Writing these out graphically can be helped by many web based tools like phpmyadmin or adminer.

You can even create indexes for columns that are slow to query. Many more optimization exist if you are will to learn them.

Source Link
cybernard
cybernard
  • 1.7k
  • 9
  • 13

At least for the CSV files I would suggest importing all of those into a sql database such as mariadb(formerly mysql).

select * from table
where (condition1 > 5) and (condition1 <10 ) and
(condition2 > 100) and (condition2 <1000 )
(condition3 > 5) and (condition3 <10 )

Writing these out graphically can be helped by many web based tools like phpmyadmin or adminer.

You can even create indexes for columns that are slow to query. Many more optimization exist if you are will to learn them.