Ask a Question related to Coldfusion Database Access, Design and Development.
-
Bulkis #1
Does splitting of the DB increase processing speed?
There's a SQL database, that Coldfusion works with. It's a one-file database
size of 1,5GB. DB consists of a lot of tables, which form three groups. Would
everything work faster if i split the DB into three separate databases, files
that is? Because, like i said, there are three groups of tables, which do three
different jobs.
Bulkis Guest
-
Processing speed in CF 4.5/5.0
I have an application that's using excessive CPU time on the server, and am looking for either ideas for tuning it, or confirmation of my suspicion... -
splitting a string
Hi: I want to split the string 0.0.0.0.1.10.1.30.1.10.1.30.1 into 4 variables: 0.0.0.0, 1, 10.1.30.1 and 10.1.30.1 any suggestions? TIA... -
Does Ruby 1.8.0 improve in file I/O speed and pattern match speed?
Hi, rubyists, I'm using ruby 1.6.8 (2002-12-24) and find file I/O too slow. Is ruby 1.8.0 faster? Some one in the list said speed is quite... -
Visual C++ and Oracle - increase speed and preformance?
3000 rows is not a big quantity. You can load it into VC program memory, a linked list for example, and "asynchronously" load into Oracle. The... -
Filemaker script processing speed on sql server databases??
Hi. I'm wondering how fast a filemaker script could process sql server data in comparison to other solutions like visual basic, or whatever else... -
The ScareCrow #2 Re: Does splitting of the DB increase processing speed?
It would make no difference if the db was split into 3 db's
Example
If there are 1000 tables, and a query did a select one one table
Campared to
If there are 10 tables, and a query did a select one one table
If both queries are the same then the query time would be the same.
Ken
The ScareCrow Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
