database-performance
Does Ruby on Rails "has_many" array provide data on a "need to know" basis?
On Ruby on Rails, say, if the Actor model object is Tom Hanks, and the \"has_many\" fans is 20,000 Fan objects, then[详细]
2022-12-31 23:02 分类:问答sybase - fails to use index unless string is hard-coded
I\'m using Sybase 12.5.3 (ASE); I\'m new to Sybase though I\'ve worked with MSSQL pretty extensively. I\'m running into a scenario where a stored procedure is really very slow. I\'ve traced the issue[详细]
2022-12-24 21:54 分类:问答Keeping Duplicates
I have an IEnumerable containing objects that have a groupnumber property. I want to be able to get a list of all objects that have duplicate groupnumbers e.g.[详细]
2022-12-17 00:11 分类:问答auto_increment value change affect performance in MySQL?
I have changed auto_increment value to 1000000 of a MyISAM table. Does this affect read/write perfor开发者_StackOverflow中文版mance? I thought that db engine may look for IDs before ID 1000000 everyti[详细]
2022-12-13 02:59 分类:问答Sql COUNT Performance Question
Structure开发者_如何学Python of Example table: Id, Integer (PK) Name, Varchar(100) Description, Text[详细]
2022-12-11 21:28 分类:问答Performance Considerations for using SQL Server Extended Properties
To All, We are wanting to use Extended Properties as p开发者_运维问答art of our database documentation.One of my co-workers mentioned that on a prior project they used Extended Properties and it impa[详细]
2022-12-08 20:49 分类:问答