Quote:
Originally Posted by cooldude7
only2 columns per table,
1 uniq id and another is numbers.
|
MySQL is probably the wrong tool for the job in that case. Under the hood, MySQL sometimes uses Berkeley DB to store the data. Berkeley DB is simple and very efficient, but it can only store key -> value pairs (what you have). MySQL does a lot of extra work to make key -> value look like a table with multiple columns of various types and make it possible to do complex SQL queries on the data. All that work is wasted if you just want to store and retrieve keys and values. For that, use Berkeley directly.
__________________
For historical display only. This information is not current:
support@bettercgi.com ICQ 7208627
Strongbox - The next generation in site security
Throttlebox - The next generation in bandwidth control
Clonebox - Backup and disaster recovery on steroids