Strings as Primary Keys in SQL Database
I am not very familiar with databases and the theories behind how they work. Is it any slower from a performance standpoint (inserting/updating/querying) to use Strings for Primary Keys than integers? ...
database
SQL Server (2008) Pass ArrayList or String to SP for IN()
Hi All, I was wondering how I can pass either an ArrayList, List<int> or StringBuilder comma delimited list to a stored procedure such that I find a list of IDs using IN(): @myList varchar(50) SELECT * FROM tbl WHERE Id IN (@myList) In C# I am currently building the list as a string which is comma delimeted; however when using...
What should be considered using subselects in queries with haevy loaded databases?
We are developing an application with a persistence layer using OpenJPA1.1 and an Oracle DB as backend storage. I will use queries with subselects (see my question at Solving JPA query finding the last entry in connected list). Now my colleagues at work remark, that such queries can lead to performance problems as the database is fille...
what is the advantage of having a users' logs records in a website?
what is the advantage of having a users' logs records in my website or forum, why I should know who sign in? and when? I am asking this question because I built a website and my supervisor he asked me let the the system record all members logs! ...
Why/how does this ambiguous UPDATE statement work?
Let's say you're running an UPDATE statement on a table, but the information you're putting into this base table is from some other auxiliary table. Normally, you would JOIN the data and not expect the rows in the UPDATE statement's FROM clause to multiply, maintaining that one new row maps to one old row in the base table. But I was wo...
How much does wrapping inserts in a transaction help performance on Sql Server?
Ok so say I have 100 rows to insert and each row has about 150 columns (I know that sounds like a lot of columns, but I need to store this data in a single table). The inserts will occur at random, (ie whenever a set of users decide to upload a file containing the data), about a 20 times a month. However the database will be under conti...
What is the best format to store images in a database?
What is the best format to store images in a database, such as binary,base64...etc, for optimal speed/size. ...
sql cross join - what use has anyone found for it?
Today, for the first time in 10 years of development with sql server I used a cross join in a production query. I needed to pad a result set to a report and found that a cross join between two tables with a creative where clause was a good solution. I was wondering what use has anyone found in production code for the cross join? Up...
Is the programmer of a database program responsible for database backups?
Imagine you sell an application that stores its data in a Microsoft Sql Server database. Some customers are large companies with existing Sql installations and staff to maintain them. Other customers are small companies who get the SQLEXPRESS version installed by a setup program. The database will soon contain a lot of important data an...
.Net Custom Libraries?
Where can I get custom libraries for ASP .Net? Specifically I am looking for ready made database access library that allow me to select, insert and update a database using transactions. I know how to do create but I am trying to use an existent library that does all that and handles exceptions and errors so exempt from the hustle of crea...
Zend Framework, run query without a view?
Hello, I am currently building a small admin section for a website using Zend Framework, this is only my second time of using the framework so I am a little unsure on something things. for example are I have an archive option for news articles where the user will hopefully click a link and the article will be archived however I cannot w...
Should I Pass UserID between application levels?
WHen submitting data to Data Layer when userID is not a field in the object being passed, but will still need to cross reference tables with userID when submitting data, should I call the the membership class to get the UserID at the datalayer, or should I pass UserID from level to level as a parameter? (ie from the business layer to th...
Multiple posts to DB with Linq
if i have two thousand webusers each sumbmitting a post to sqldb through website at the same time same tables, will linq handle this without any problems? ...
Showing data and counting from multiple databases in MySQL
I have two tables, that is joined in some way. I've spent the last hour googling around, not finding any concrete answers that worked in my case. The case is, table 1 is called Clients, and table 2 is called Projects. I need to list all the client names, followed by number of projects related to that project and the project title. For ...
Which embedded database capable of 100 million records has the best C API
I'm looking for a cross-platform database engine that can handle databases up hundreds of millions of records without severe degradation in query performance. It needs to have a C or C++ API which will allow easy, fast construction of records and parsing returned data. Highly discouraged are products where data has to be translated to a...
Understanding ASP.Net & Databases
I could do with a bit of guidance understanding the world of asp.net & databases. There seems to be so many options I'm not really sure what to look into & what to use in different situations. I've created websites that have used datasets in the past, but I never really understood what was going on or why I should or shouldn't be using...
Deleting Database in Linq
In normal condition, I can add schemas in the dbml file to empty database with code below. But now when I run this code, I take the error "Cannot drop database "test" because it is currently in use." How can I do it? Dim db As New UI_Class.UIData If db.DatabaseExists Then db.DeleteDatabase() End If db....
What is the best way to access data in a normalized database schema?
I've got a problem that keeps coming up with normalized databases and was looking for the best solution. Suppose I've got an album information database. I want to setup the schema in a normalized fashion, so I setup two tables - albums, which has one listing for each album, and songs, which lists all songs contained by albums. albums ...
Which lightweight database should I use in a Firefox extension?
I currently use a flat-file to store data in a Firefox Extension, but think this is inadequate. Which lightweight databases are commonly used within Firefox extensions? ...
What is the best way to persist PHP application setings?
I have a small application that I'm developing, that I may want to give/sell to others. I want to persist some settings, and create an admin interface to modify them. What would be the best way to store them away? A DB table seems like overkill for the 10-20 settings I'll have, and I want the retrieval of these settings to be as fast ...