Database building.... how?

[ratboy]

I want to build a database of 2m items. How do I do it? Excel only allows me 50,000 (is it) lines, how else do people build the huge ones?

thanks :???:

 

[Jeewhizz]

Real people don't use a spreadsheet program, they use a database

You could use Access if you have access to it (pun intended)

Or you could build one in PHP / MySQL

 

[ratboy]

Access, yeah i've got that. Thanks

 

[niky]

Go for MYSQL. Its a free database. If you are buying hosting space ask for MYSQL/PHP(Generally most hosting companies offer it free).
Postgres is another option.
_____________
Hotels in Edinburgh ltd Pyramid Belt

 

[accelerator]

I would also recommend MySQL and php rather than using Access.

Rgds

 

[Skinner]

Access will die of heart failure or cerebral embalism if you put 2 million records in a table.

Its not a record limit but a total database file size, which is 1gb-2gb depending on which version of access.

If you think 1gb is 1,900,000 records at 512 characters (got to allow overheads+structures and sql etc), this is TOTAL DB not per table.

MySQL will handle 2,000,000 records but your going to need some pretty bloody neat sql code, normalisation, appropriate indexes and I'd use temp tables and some form of cacheing as well, to allow it not to bring your server to its knee's. Dealing with 2,000,000 records and poor code will anhiliate your server. Maybe worth hiring a database expert to write your SQL, because you can turn a requirement for a £500 a month server into shared hosting requirement is fantastic code.

I know someone who has a wiki running with 15,000,000 records and has no problems, phpbb.com's forum must be 100s of millions or records.

Oracle should also be considered as well.

 

[aZooZa]

Depends what type of data you wish to store. If it's a list of domain names you could even use a flat file. I have a .com zone database with 80 million records in it, and I use unix sed, grep and awk to search and parse it which works really easily. If you want to perform calculations on any of the data then you'll need MySQL or similar. My version of Excel will do 65,535 records, as record numbers max out at 0xFFFF which is another astonishing Microsoft system anachronism from the old DOS days.