How long will it take in mysql to fetch 4-5 lac rows and for each row hit the database with some more queries?
548031
It would almost impossible to give you an estimate of the time involved.  Getting good performance from MySQL isn't much different than other apps: Get a fast CPU and FSB, lots of RAM and SCSI hard drives with a quality SCSI Adapter.\n\nMake sure your MySQL database has indexes built for the queries you'll do most often.  Choose your table types (MyISAM, InnoDB,  ISAM, etc.) carefully for the type of work you're doing.  Choosing the right table type will give you better performance.\n\nIf you have the money, set up Master/Slave servers and let the Slave handle some of the read requests.  \n\nVisit the MySQL website for more good information on how to get the best performance from your box.
556712
There are numerous tutorials on how to query an mysql database with php. After that all you have to do is to post the values you want and your java script will read them. It depends so much on what you want to accomplish. If you have a clear image of the final product it is easy to be done.
731565
In any DBMS, the data which you input will be stored in the form of records(rows). Its easier in this way to track down a particular record that you are looking for in the DBMS with the help of the Index which will be created in the database, 'coz of which time consumption will be less.\nHope this will help you.
708972
Depends what configuration you have... If you're running on a lower performance computer and you have a lot of apps installed, it will take a while untill the list is filled (it could last a few minutes)...(On my old Duron 700Mhz with 256ram  i had oracle 9i installed and working:D, .NET 2001 and other programming stuff and it took me 5 minutes as I remember until that list was "filled"...).
1001381
how about creating a dynamicly driven website with SQL engine.  Where you can add stuff and easily search it in the search bar.  That would be a good one for you.
751832
It's supposed to be unlimited. In real-world applications though I'd cap the max. number of addressable rows at 32 bit (4 billion rows). If you go over that you're either going to crash, or have some serious performance issues. 4 billion rows is only insufficient if you're trying to do something like catalog every man/woman/child on earth.\n\nUse "BigInt unsigned" for storing 64 bit unsigned... Considering the size of your data set, this could save you considerable space (8 bytes per entry instead of a potential 21).\n\nI know this exists in MySQL v 5.0, I don't know about other versions. Be ~careful~ when doing math with numbers of this size. Very often they'll get rounded.\n\nMore information about numeric data types in MySQL 5 can be found in my source link below.
1007417
Hi..\nCheck out the following page...this might provide your some insight on Query Optimizations...\nhttp://www.sqlsummit.com/Optimization.htm
275090
It depends on the type of database.\n\nFor Access, assuming your dates are stored in a Date/Time field:\nSELECT * FROM table WHERE start_time > #1/2/2004 21:43:24# AND stop_time < #1/3/2004 6:43:24#\nOptionally, without time:\nSELECT * FROM table WHERE start_time > #1/2/2004# AND stop_time < #1/3/2004#\n\nMake sure you order your dates by the proper locale; e.g, mmddyyyy or ddmmyyyy.\n\nNote also that I did not use stop or start as column names. Those are reserved words in just about every relational database.\n\nFor Transact-SQL (MSSQL), assuming your columns are  DateTime, send your dates as strings:\nSELECT * FROM table WHERE start_time > '1/2/2004 21:43:24' AND stop_time < '1/3/2004 6:43:24'\n\nFor MySQL, assuming you are using an int column to store a Unix timestamp, just send Unix timestamps:\n\nSELECT * FROM table WHERE start_time > '1433232923' AND stop_time < '1433732923'
25643
I've included some helpful links listing SQL commands.  Note that some may depend on what specific database you're using (Access, MySQL, PostgreSQL), so you should check the reference for that product.
393030
See the reference below.  The documentation has some examples. \nFailing that MySQL has a C API which you could use from C++.
573387
Already on the right track here, so I will just add some clarification. Also note that I'm using MySQL here and avoiding nested select statements for compatibility with older versions.\n\nSometimes it's best to construct a query a small amount at a time so that you can see the effect. To keep the samples concise I will check on one field only. First, check the different results for the following....\n\nSELECT \npay_date, \nu_date,\nFROM \nsales, pay\nWHERE \npay_date = u_date\n\n\nNow compare this with...\n\nSELECT \npay_date, \nu_date,\nFROM \nsales\nLEFT JOIN pay\nON pay.pay_date = sales.u_date\n\n\nNotice how in the left join, the rows that fail the match still appear, but with NULL as the field? That's where the answer lies...\n\n\nSELECT \npay_date, \nu_date,\nFROM \nsales\nLEFT JOIN pay\nON pay.pay_date = sales.u_date\nWHERE pay.pay_date IS NULL\n\n\nWhen a value has the potential of not being unique, you can test for it's existence or lack thereof with something like this:\n\nSELECT \nsales.u_store,\nIF(COUNT(pay.pay_date) > 0,'Yes','No') as 'Date Exists'\nFROM \nsales\nLEFT JOIN pay\nON pay.pay_date = sales.u_date\nGROUP BY sales.u_store
83897
try this out:\n\nhttp://dev.mysql.com/doc/
238613
How many items? If it's over 1000, you better go with access, or get frustrated trying to use excel (unless your needs are very simple). I think excel has a limit of about 65535 rows, but if your tracking that many, you definitely want to use a database such as MS Access.
187676
Your best bet would probably be a list of checkboxes to match each question.\n\nOnce all the checkboxes have been filled in then submit the form and all the information gets transfered to a database.\n\nDo this as a standalone webpage with a DB backend. Probably something like mySQL or SQL2k, SQL2003 would be your best bet as Access only supports 10 connections at a time and you may overload this if you have multiple people entering data at the same time.
896456
mySQL should be part of your solution.\n///
1007763
For a free price, MySQL is very good.  We use it at work for our database applications.
308995
Normally you use a database to serve up dynamic content instead of just storing 1000 flat pages.  I would go ahead and copy and paste, or come up with a series of scripts that will do it for you.