Re: [PHP-DB] When does using multiple tables make sense?

2008-10-26 Thread Lester Caine
Liam Friel wrote: 2008/10/20 Lester Caine [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Jason Pruim wrote: So my question is... When is it best to use more tables? All the info will be related to each other, so I think I would be looking at either a many-to-many

Re: [PHP-DB] using database without mysql installed

2008-10-26 Thread Chris
Patrick Price wrote: I am trying to access a mysql database server from a php 5.2 server that doesn't have mysql installed on it. I don't have access or the ability to reinstall php on this server. Is it possible to install mysql after php is installed and up and running? Of course. php

[PHP-DB] Help needed - SELECT query optimization

2008-10-26 Thread Nitsan Bin-Nun
Hi, I have a mysql database with one table in it, currently it contains 36,807 records and it costs 6.8MB of space, every night another thousand~ of rows are being added to the table. The scheme (as taken from phpmyadmin) is like follows: CREATE TABLE IF NOT EXISTS `search` ( `id` int(11) NOT

Re: [PHP-DB] Help needed - SELECT query optimization

2008-10-26 Thread Chris
It should be a rapidshare links database (which updates with a PHP crawler I wroted last Saturday). I would like to change the snippet to title and add another column for the snippet, My main queries are INSERT's - a big insert (usually 10-100 links per insert) in each hour. My crawler is