Search Results

Search found 30279 results on 1212 pages for 'database drift'.

Page 793/1212 | < Previous Page | 789 790 791 792 793 794 795 796 797 798 799 800  | Next Page >

• postgres too slow

  - by Killercode

  Hi, I'm doing massive tests on a Postgres database... so basically I have 2 table where I inserted 40.000.000 records on, let's say table1 and 80.000.000 on table2 after this I deleted all those records. Now if I do SELECT * FROM table1 it takes 199000ms ? I can't understand what's happening? can anyone help me on this?

  Read the article

• Form Authentication in ASP.NET MVC

  - by Renu123

  hello, can any one tell me how to do form authentication in asp.net mvc? i had done form authentication for built in database but i dont know how to use it with ADO.net entity model. thank you

  Read the article

• Changing the output of Getdate

  - by pauloya

  Is it possible to deceive SQL Server to return a different date on GetDate() without actually changing the machine date? This would be great, since we have a database with old data and I'm trying to test some queries that use getdate(). I can change my machine date but that brings some other problems with other applications... Any tips? Thanks!

  Read the article

• RETS data fetching problem.

  - by Jimit

  Hello everyone, I am working on one real estate website which is Using RETS service to get the data to my local server. but I have one little bit problem here,I can fetch data from RETS which is having about 3lacks record in RETS Database but I didn't find the way,How can I fetch that all records in bunch of 50k at a time ? I didn't find any 'LIMIT' keyword on RETS.so how can I fetch without 'LIMIT' 50k records at a time? Please help me.

  Read the article

• PHP: How do I convert a server timestamp to the user's timezone?

  - by KeyStroke

  Hi, I'm currently storing times using the 'time()' function in the database. However, it's using the timezone of the server, and I'd like for each user to see the time according to their timezone (set in their profile). How do I do the timestamp conversion? (and I mean from timestamp to timestamp, not to readable time) Your help is appreciated

  Read the article

• Oracle 10g express edition import

  - by Jasim

  How can i import a DMP file into my oracle 10g expression edition database? I tried with imp but its showing an error: IMP-00010: not a valid export file, header failed verification IMP-00000: Import terminated unsuccessfully How can i solve this?

  Read the article

• How to scale php application servers horizontally?

  - by Kirzilla

  Hello, I'm using lighttpd as webserver for php application server. The avg. load on this server is about 2-3. MySQL database is separated to another server (it's load ~0.4). How could I scale php application server? Thank you.

  Read the article

• Page_Load after Modal Popup

  - by n0chi

  I have a page with a user control which gets some data updated via a modal popup. Upon clicking "ok" on the modal popup - the new data is being written to the database - but the base page doesnt "reload" to show the updated data. How do I get that to happen?

  Read the article

• oracle index for string column - does format of data affects quality of index?

  - by Jayan

  We have following type of "Unique ID" column for many tables in the database (Oracle). It is a string with following format <randomnumber>-<ascendingnumber>-<machinename> So we have some thing like this U1234-12345-NBBJD U1234-12346-NBBJD U1234-12347-NBBJD U1234-12348-NBBJD U1234-12349-NBBJD The UID value is unique, we have unique index on them. Does the following format is more efficient than above for index scans? NBBJD-U1234-12345 NBBJD-U1234-12346 NBBJD-U1234-12347 NBBJD-U1234-12348 NBBJD-U1234-12349

  Read the article

• Not able to create a datasource registration with WAMP MysQL 5.0 in DBArtisan

  - by Alf Christophersen

  I try in a test version of DBArtisan to set up a datasource and register both servere as localhost, database to use, my username and password, but, when testing the connection, I get message that connection failed. Hooking up from eg. Delphi and other utilities run nicely. But not DBArtisan, Is MySQL 5.0 not supported yet ?? Or is it WAMP that is the culprit naming the service wampmysqld insted of just mysqld ??

  Read the article

• Conditional use of wp_list_categories (Wordpress)

  - by YsoL8

  Hello I am using the wp_list_categories tag in Wordpress. I would like to wrap this in a condition so it is only used when there are posts in the database. Something like: if ($number_of_posts > "0") { } But I can't find a function that'll let me count the number of posts. Anyone know the solution?

  Read the article

• how to send multiple row to mysql at same time(like bulk copy)?

  - by Ayyappan.Anbalagan

  I am using asp.net + Mysql. I have multiple rows in my dataset; I have to store the rows in my database table. How to do that?

  Read the article

• Assign query results to MySQL variable

  - by 5un5

  I'm querying a big mysql database with only read privileges, and I'd like to set some slow query results to a variable, 'foo', so I can use them again in other queries. I get, ERROR 1193 (HY000): Unknown system variable '$foo' when I enter: set $foo := (select * from table1 join table2 where bar = 0 group by id); Is there a way to do this with variables, since I don't have privileges to create temporary tables?

  Read the article

• how to reverse the order of words in query or c#

  - by Ranjana

  i have stored in the database as location India,Tamilnadu,Chennai,Annanagar while i bind in the grid view it ll be displaying as 'India,Tamilnadu,Chennai,Annanagar' this format. but i need to be displayed as 'Annanagar,Chennai,Tamilnadu,India' in this format. how to perform this reverse order in query or in c#

  Read the article

• If there is a necessary data base

  - by Dmitry

  Hello! I have a desktop program which uses an embedded data base mechanism. For the first time a user will execute a program, it must create a database. So that, next time there is a data base and there is no need to create it. Please, tell me, how to chech if there is a necessary data base.

  Read the article

• Is it advisable to store things such as list of cities on the db?

  - by grokker

  Hi I'm using CakePHP and I'm wondering if it's advisable to store things that don't change a lot in the database lik the list of cities?

  Read the article

• SQL Math in Excel VBA

  - by Scott

  Excel seems to have a problem with doing math in SQL queries. SELECT ( SELECT sum(column) FROM table1 ) + ( SELECT sum(column) FROM table2 ) AS total This technique works completely fine in ASP and ASP.NET. Has anyone had success doing this in Excel VBA? (My database engine is SQL Server 2000.)

  Read the article

• How can I tell that a domain transfer has been successful?

  - by Kieran

  I'm currently transferring from Fasthosts (UK) to 123-reg. Whe WHOIS database says the domain is with 123-reg, but it isn't. Has something gone wrong here, or does it just take a while? Also, will the domain disappear from my Fasthosts control panel when the transfer is complete? Many thanks

  Read the article

• Is it possible to Load hbm.xml info at app startup instead of via an embedded resource?

  - by Daniel Auger

  All of the NHibernate examples I've see that use hbm files have the hbm.xml file set as an embedded resource with "do not copy" chosen in the file properties. This means that if a database column name were to change in production, the app would have to be recompiled with the changes in the hbm.xml file during build time. Is there any way to make NHibernate load the hbm.xml files from the file system at application startup instead of using an embedded version?

  Read the article

• Suggestion for developing search engine

  - by MohamedGooner

  I want to develop a simple search engine, using ASP.NET and C# , where I can search for a word which contained in a very big text (like the Holy Bible or something like that), then the program shows the user where the word is. I have no idea about in which database I can put this large text and using which method will I search for a word. Any suggestions will help me, and if anyone have a tutorial for anything similar it will benefit me.

  Read the article

• Does a syntax for this exist? In any language?

  - by Michael

  It seems pretty common to me to have an argument, in a dynamically typed language that is either an Object or a key to lookup that object. For instance when I'm working with a database I might have a method getMyRelatedStuff(person) All I really need to lookup the related stuff is the id of the person so my method could look like this in python: def getMyRelatedStuff(person_or_id): id = person_or_id.id if isinstance(person,User) else person_or_id #do some lookup Or going the other direction: def someFileStuff(file_or_name): file = file_or_name if hasattr(file,'write') else open(file_or_name)

  Read the article

• Calculating percent of votes inside mysql statement.

  - by Beck

  UPDATE polls_options SET `votes`=`votes`+1, `percent`=ROUND((`votes`+1) / (SELECT voters FROM polls WHERE poll_id=? LIMIT 1) * 100,1) WHERE option_id=? AND poll_id=? Don't have table data yet, to test it properly. :) And by the way, in what type % integers should be stored in database? Thanks for the help!

  Read the article

• Windows Media Service authentication issue

  - by George2

  Hello everyone, I am using Windows Server 2008 R2 with Windows Media Service. At the client side, I want to use Silverlight to play the media file. I am using VSTS 2008 + Silverlight 3 + ASP.Net + .Net 3.5. I want to know how to implement a custom authentication protocol (I have a custom user database, which contains user name and password. I want to enable logged-in user to be able to play through Silverlight)? thanks in advance, George

  Read the article

• HIbernate - HBM.xml Automatic generation from DB Schema

  - by frappuccino

  Is there any plugin available for Eclipse or Netbeans or any other IDE which can help me generate the hbm.xml by directly reading the schema from the database. Writing those XMLs seem to be unnecessary waste of time, and feel it should be automated.

  Read the article

• Client/Server communication via internet

  - by user957829

  Hi, Which is the best solution to communicate bidirectionally between a remote server and a client behind an internet box? UPnP with Sockets. HTTPS/Database Server and the client make 1 request every Xsec to know if there is new data. Client opens 1 connection on the server and it maintains open to make a tunnel. Thanks in advance for your help

  Read the article

< Previous Page | 789 790 791 792 793 794 795 796 797 798 799 800  | Next Page >