Questions about database performance and tuning, ranging from files organization and configuration to benchmarking and system optimization, passing through management systems and the fastest ways to operate a database.
I have a simple mysql query, but when I have a lot of records (currently 103,0000), the performance is really slow …
mysql performance database-performance filesortI've noticed that a lot of folks here cite tables with 20+ (I've seen as much as 55) columns in one table. …
database database-design database-performanceI use Talend to load data into a sql-server database. It appears that the weakest point of my job is …
sql-server database-performance talend upsertI have MySQL 5.5.37 with InnoDB installed locally with apt-get on Ubuntu 13.10. My machine is i7-3770 + 32Gb memory + SSD hard …
mysql performance database-performance ddlI know there's a lot of these questions, but I can't find one that relates to my question. Looking at …
sql-server tsql database-performanceI have a table CANDIDATE in my db which is running under MySQL 5.5 and I am trying to get rows …
mysql regex database-performanceI could see the DBA team advises to set the sequence cache to a higher value at the time of …
oracle database-performanceI'm doing a project that deals with structured document database. I have a tree of categories (~1000 categories, up to ~50 categories …
database git database-performance database-replication document-databaseI need to implement Categorization and Sub-Categorization on something which is a bit similar to golden pages. Assume I have …
sql-server database categories database-performanceI have written a daemon processor which will fetch rows from one database and insert them into another for synchronizing. …
postgresql indexing database-performance database-replication