Search Results

Search found 31628 results on 1266 pages for 'legacy database'.

Page 269/1266 | < Previous Page | 265 266 267 268 269 270 271 272 273 274 275 276  | Next Page >

• Tracking down data load performance issues in SSIS package

  - by SteveC

  Are there any ways to determine what the differences in databases are that affect a SSIS package load performance ? I've got a package which loads and does various bits of processing on ~100k records on my laptop database in about 5 minutes Try the same package and same data on the test server, which is a reasonable box in both CPU and memory, and it's still running ... about 1 hour so far :-( Checked the package with a small set of data, and it ran through Ok

  Read the article

• Can splitting .MDB files into segments help with stability?

  - by Craig Johnston

  Is this a realistic solution to the problems associated with larger .mdb files: split the large .mdb file into smaller .mdb files have one 'central' .mdb containing links to the tables in the smaller .mdb files How easy would it be to make this change to an .mdb backed VB application? Could the changes to the database be done so that there are no changes required to the front-end application?

  Read the article

• best way to export data from pdfs

  - by michael

  Hi i work at a news paper and we are lookin a way to make archieve material available. Atm our pages come in pdf format so we need a way to export text and images from the pdf so that they can be added to a database. We've had a look at the News studio plugin for Adobe Acrobat from Iceni Technology, but just wondering if anyone else knows other options for exporting pdf data. thanks

  Read the article

• Automatically connect to a DB in a swing application

  - by Oussama

  Hello, I m working on a single user swing application that access an hsqldb database. How can i Automatically run the DB server when a user run the application.? for example, after i finish development i will put the application into an exe file. If the exe file is distributed to multiple users. How can the DB server run and the DB be created when the user run the exe file? Thanks

  Read the article

• Magento - get list of items from orders for specific date range

  - by ms80

  Magento database name convention is not trivial. How to get these fields below for last 7 days? Last Name First Name Address City State Zip Phone Email Amount Order # Item #

  Read the article

• SQLite If Column Exists

  - by Nathan

  I was wondering if there is a nice IF NOT EXISTS for checking columns and indexes in SQLite, or do I need to bring back the entire database schema and validate against that?

  Read the article

• DAO method retrieve single entry

  - by London

  Hello, How can I write DAO method which will return as a result only first entry from the database. For instance lets say I'm looking at Users table and I want to retrieve only the first entry, I'd declare method like: public User getFirstUser(){ //method logic } EDIT: User has primary key id if that matters at all. I apologize if this question is too simple/stupid/whatever I'm beginner with Java so I'm trying new things. thank you

  Read the article

• What are good alternatives to SQL?

  - by Brendan Long

  I occasionally hear things about how SQL sucks and it's not a good language, but I never really hear much about alternatives to it. So, are other good languages that serve the same purpose (database access) and what makes them better than SQL? Are there any good databases that use this alternative language?

  Read the article

• MySQL ORDER BY rand(), name ASC

  - by Josh K

  I would like to take a database of say, 1000 users and select 20 random ones (ORDER BY rand(),LIMIT 20) then order the resulting set by the names. I came up with the following query which is not working like I hoped. SELECT * FROM users WHERE 1 ORDER BY rand(), name ASC LIMIT 20

  Read the article

• Reasons to store users' data in LDAP instead of RDBMS

  - by Ancymon

  It is often said that using LDAP is a good way to store data about users. That's beacause users' "directory" is hierarchical and it changes rarely. But in my opinion that doesn't exclude using RDBMS. What might be reasons to use LDAP? I guess that storing multi-valued fields or adding custom fields in LDAP might be easier but it can be done in database too (unless you have many records)

  Read the article

• Can I query inside a SQLite Transaction?

  - by CSharperWithJava

  I'm using the SQLite3 database system in the Android library. I need to execute a query during a transaction to see if there is a similar entry already there. If there is, I have to perform some other logic and adjustments before I add a new row. Can I execute a query within a transaction and get the result back immediately?

  Read the article

• Android Cursor over Generic list of business objects?

  - by BahaiResearch.com

  In .NET land I would normally query the database and populate a generic List kind of collection. Then the app would use this. In Android land I have been reading about DB access and use in apps. Why do most of the docs show the use of a cursor and use of constants to access it? Is this to save on resources perhaps?

  Read the article

• SqlConnectionStringBuilder form in .net C#

  - by adopilot

  I am wondering how I can add DATA LINK form to my WIN application. You know those forms where Users can choose on witch SQL server they going to connect and what type of security they going to use and on wht database. Something like on this picture

  Read the article

• storing original password text

  - by Richard

  My application stores external website login/passwords for interaction with them. To interact with these website I need to use the original password text, so storing just the hash in my database is not going to work. How should I store these passwords?

  Read the article

• block write access to table from an application in mysql

  - by hoberion

  Hello, We have a CMS plugin that writes statistics to 1 table, this creates performance issues on the entire platform. We decided to use another statistics plugin which can connect to a different database server (the first plugin couldn't!) however we need parts of the first plugin. I want to lock the statistics table to prevent misusage (not allowed to drop it by the developer) So I was wondering if a lock table could do this or if I can implement some sort of read only table

  Read the article

• Is there a GUI which will enable me to query an XML file?

  - by Johnny

  hi, I have an XML file which I'd like to query (read/write) in the same way as I would a relational database. Performance is not a big issue, I just want to be able to load the file and start querying, preferably without having to define a schema. Does anyone know if such software exists?

  Read the article

• Any SMO C# Library?

  - by gtas

  Anyone knows any library for SQL Server database backup and restore for C#? This actually is needed to avoid writing one new. There is so many people out there giveng they're libraries, but i found strange i couldn't came up with googling anything related. Thank you.

  Read the article

• Io exception: There is no process to read data written to a pipe.

  - by Srikanth

  I'm using Hibernate3.2+Websphere6.0+struts1.3.. After deploying ,application works fine. After some idle time ,i will get this type of error repeatedly,am not able to login at all. Im not using any connection pooling. i feel after idle time its not able to connect to the database again..if i restart the server everything works fine for some time...after that same story.. please help me out

  Read the article

• What is some good software for designing MySQL databases?

  - by franzferdinand

  As above. Usually at work someone else does the database design, and when I do personal projects they're small enough to not really require more than five or six tables, but I'm about to start a personal project that I think will probably require around eleven or twelve tables and I'd like something to help me design it neatly and keep track of it.

  Read the article

• How can I drop table if Entity Mode in Hibernate properties is Dynamic-Map?

  - by divi

  Hi all, My application is creating tables dynamically using entity mode as dynamic-map in hibernate properties. Tables are generally network devices having their attributes as columns of table. Requirement is if device is deleted from database, its table will be deleted. Can i drop table using hibernate tools dynamically?

  Read the article

• Versant OQL Statement with an Arithmetic operator

  - by Pascal

  I'm working on a c# project that use a Versant Object Database back end and I'm trying to build a query that contains an arithmetic operator. The documentation states that it is supported but lack any example. I'm trying to build something like this: SELECT * FROM _orderItemObject WHERE _qtyOrdered - _qtySent > 0 If I try this statement in the Object Inspector I get a synthax error near the '-'. Anyone has an example of a working VQL with that kind of statement? Thanks

  Read the article

• java mapping for oracle number type

  - by aauser

  I have database with oracle number type. Could there any possible issues with using java Double when updating table with numeric column. Should i switch BigDecimal or Double is approriate type. As I fas as I know, BigDecimal is used when arbitrary precision required, when deal with prices for example. Consider simple API updatePrice(Double d) Should i persist double as is or BigDecimal.valueOf(d) is preferable ?

  Read the article

• Do all databases use the USE statement to switch databases?

  - by thearchitect

  MySQL uses the USE database_name to change the active database. Does that work on all databases? EDIT: By databases I mean DBMS. Thanks for bringing it to my attention.

  Read the article

• how to load a file into a blob without loading into RAM first?

  - by Ace Grace

  Hi, I am using C# and I am having trouble loading large files into a binary field use byte arrays. Basically, if I load a file that is too large, I get memory problems. Is there a way to load a file into a binary field without using large amounts of ram, i.e. avoid loading the file into memory first? If it helps, I am using Advantage Database Server and this is using a winforms app not a web app. Regards

  Read the article

• How to display content of one site in another using PHP?

  - by Joyan

  Hello I'm trying to show contents of two websites in one another , someone suggest me to use RSS reader but my question is : is there anything else i could try to show the contents , beside using rss !? i thought i can connect to the database of another website , but that didnt work / thanks in advance

  Read the article

< Previous Page | 265 266 267 268 269 270 271 272 273 274 275 276  | Next Page >