Technical Question

[flac0]

Hi!

I'm designing a DB for a phone system and it must be access in realtime giving the account information to make the call.

Here is my question:

I know that the difference to access to tables without foreing keys are faster than tables with foreing keys, but how much?

It´s a good design idea to get off all foreign keys in tables that it will access in realtime?

any suggestion are welcome...tanks!

I apologize by my poor english!

 

[svanels]

"I know that the difference to access to tables without foreing keys are faster than tables with foreing keys"

My answer is No. The foreign key is to prevent entering invalid data, or removing data in the database, so when entering or deleting the Database consisteny will be checked. This process is done in a very short time "mili seconds or nano seconds"


On the other hand look-up fields require more processing time etc. All depends on your database structure and amount of data/tables.
Steven van Els
SAvanEls@cq-link.sr

 

[Luther1978]

Do you mean indexing your fields rather than setting them as a foreign key???

Setting more fields as an index makes searches within the Database more efficient and quicker. Whilst making the database bigger and more cumbersome.

Feel free to correct me if I'm wrong, I'm no expert.


M King

 

[sem]

Using foreign keys may slow down INSERTS, not SELECTS. As for nanoseconds, the speed definitly depends on TABLE SIZE and INDEXES AVAILABLE.