I'm using Hibernate backed JPA as my persistence layer. I have a multi-threaded process that aggregates data from a Soap call and then stores a row in a database. The process usually ends up inserting about 700 rows and takes about 1 - 3 hours, with the Soap calls being the main bottleneck. During this entire process the table I am ins...
I haven't used CiviCRM before and I was asked if I can install it on a Joomla-based web site. I also need to import about 3,000 records from 4 different MS Excel files. I'm hoping I can do this in 10-12 hours, but I haven't used CiviCRM before, and I'd like opinions from anyone who has experience with this. I know a precise figure isn't ...
I have a table in which I have two fields i.e name of the product and release date (type:date)... ->>I want to select all the products which have not been launched yet!!! Thanks... ...
Is there a limit on the SQL query string you can pass to MySQL for it to execute? ...
Hello. Is there a standard way to simulate a table creation in a database by using SQL? I don't want the table to be created, just check if it could be created. One way would be to create it and then delete it again. Any other way? ...
Hi I've recently started using Visual Studio 2008 and SQL Server Express. I'm coming from a Emacs/Django background, so I'm not used to this way of working. Is there any quick and easy way to set up a many-to-many-table between two other tables? This would be the equivalent to the table generated by a ManyToManyField in Django. ...
Possible Duplicates: Should I store Enum ID/values in the db or a C# enumeration? Persisting Enums in database tables Quick and easy question which will probably be fodder for discussion: Let's say my application has an enum with 2-3 values which are basically never going to change. Do you think those should be represented i...
I just want to ask which out of the two ways of storing data would give my better results A. Storing data in a single table with over 20+ columns OR B. Distributing the data into two tables of 15 and 6 columns each one more thing, even if I distribute the data I still might have to access both the tables at the same time in 60% of c...
Recently, I and my colleagues, we are discussing how to build a huge storage systems which could store billions a pictures which could searched and download quickly. Something like a fickr, but not for an online gallery. Which means, most of these picture will never be download. My colleages suggest that we should save all these files...
If this question is too broad, my apologies. I am a DBA and I am working with a developer that thinks column defaults are a bad idea and that just setting the column to disallow nulls is good enough. I am looking for the benefits of column defaults from the developers point of view. Thank you for your comments. ...
I'm trying to use rsync to backup MySQL data. The tables use the MyISAM storage engine. My expectation was that after the first rsync, subsequent rsyncs would be very fast. It turns out, if the table data was changed at all, the operation slows way down. I did an experiment with a 989 MB MYD file containing real data: Test 1 - recop...
I have an Oracle login with which to connect to a remote Oracle db. I am using jdbc thin driver. After a successful connection, my navigation view does not display the table I have access to. However, I am able to do a select on a table I have access to. I tried a few other db tools, like Navicat, Aqua, and the db tool in Eclipse, but s...
I need to copy a table I already I have in a SQL server database, but I don't need th edata contained in the source table. The examples I found only involve copying the data. Copy the table structure only, not the data. Source and target tables are in the same database. Target table does not exist yet. Need to do this programmatically...
I have an Access MDB file on a different server than my ColdFusion server, is there any way I can get ColdFusion 8 to be able to connect to it over the network? ...
should I call lo_unlink ? A delete didn't remove the object from pg_largeobject. ...
I'm profiling some APIs to see which one is suitable for this project. I want my Qt app to connect to a database over an internet connection. Can Qt do this with the client application alone or do I need to write a server app to sit on the database server and transact the queries? ...
Hello, In the application I am designing, I have to communicate with a device and store a history of data readings in a database. The device is essentially a sensor that spits out numbers via the serial port. The user end of the application is a RubyOnRails interface that allows the user to view this data and configure the device. I a...
Hi, I created a web service which is called from the client side to store the data into the database. These data are sent every 200 ms from a single user and each time the data are sent the database connection is opened and closed which I believe is not good for performance. The data are stored by calling REST.StoreAcceleration() metho...
With the rising of non-sql database usage in high traffic website, I'm interested to use it for my project. Now I've heard several names like Voldermort, MongoDB and CouchDB. But which are among these NonSQL database that is production ready? I've seen the download pages and it seems that none of them is production ready because is not v...
How would I achieve a persistent database connection in C? Please help me. ...