|
"Manipulate" 100 million records per hour?
Ask Amazon or Google to host your data.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
sir, in this context i used "manipulate" for "searching"
|
|
|
|
|
Then you are using the wrong terms. "Manipulate" means updating, inserting or deleting records. Reading doesn't manipulate the data, it fetches it. Selecting a few million should be doable, depending on the hardware and software-combination and the skillset of the dba.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
sorry, for all this.i have corrected my reply.
|
|
|
|
|
Databases are optimized to work with records; there will be a HUGE difference between searching records (select using a where) and searching a specific substring within a NTEXT field.
If you are going to search within the contents of the fiels, you'd be wanting a full-text search catalog. Again, supported by most major databases, but their speed may vary wildly.
Can you post a schema of the data that you'll be storing? Should I be thinking about simple data like measurements or prices? (lots o' fields with numbers) Or more toward text? (lots of short readable text-fields, like profiles), more toward memo's (single large textfield), or even documents (Word, PDF?)
In the case of documents I'd suggest to dump the files in the filesystem - and to use something like Google Desktop Search to search for specific terms.
Agent_Spock wrote: sorry, for all this Don't be; for someone who doesn't code all those things might sound roughly the same. Sorry for my short and blunt answers.
Live long and prosper
|
|
|
|
|
no sir, it consists of data which is converted into bytes.
|
|
|
|
|
Everything that a computer stores is encoded in bytes; images, text, applications - they're all stored as bytes. Hence, the remark that it's going to store bytes is not very helpfull. That way I'd assume a large binary blob, and "searching" to be a series of bytes.
Those bytes represent something; data, in whatever form. What "kind" of data you're going to store determines the best approach.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
no i am using it in such way that each record has max. 25 letters
|
|
|
|
|
Then your search terms are "Free Text Search" and the name of your database
It's described for SQL Server here[^], or you could google for Lucene.NET.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
I have two table such as table1 and table2
using sql joining query i have fetched or shown some desired result
but for good looking i want to create some extra user defined columns, which i can't create...
Please help as early as possible...
|
|
|
|
|
Hi,
I'm not sure what are you trying to do... Maybe you could give some example?
|
|
|
|
|
In your query you include the calculation and give the result a name, it is then treated as a column in your result set.
Select Town, Region + ' ' + State as Place
from TableName
This will create a column called Place in your result set.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
First Create a new table with using select command and then you can fatch data from those tables. And after that you can add any column in new table.
|
|
|
|
|
I have a table named as depot_mstr having attributes, are the following---
regn,
depot_code,
depot_name,
city
I have also an another table as dealer_list having attributes, are the following---
depot_no,
depot_code,
dealer_name,
dealer_category
how i get the output as---
regn| depot_code| dealer_name| GC| SC| STA| OTH
where,
GC, SC, STA, OTH are the elements of dealer_category
|
|
|
|
|
Assuming you are using sql server:
SELECT regn, depot_code, dealer_name, GC, SC, STA, OTH
FROM
(SELECT regn, depot_mstr.depot_code, dealer_name, dealer_category FROM depot_mstr LEFT
JOIN dealer_list ON depot_mstr.depot_code = dealer_list.depot_code
) AS sourcetable
PIVOT
(
COUNT (dealer_category)
FOR dealer_category IN
(GC, SC, STA, OTH)
) AS pivottable
|
|
|
|
|
Please also send me the code as early as possible, if i solve it through function in sql server...
Thank u...
|
|
|
|
|
I can't find any case using in the query....!!!
|
|
|
|
|
Hi,
I am planning to move my existing client database from MySQl to Oracle.
I will go for Express (because it's FREE)
I want to ask is the 11 GB Express is proving enough? I mean is it just 11 GB for my data or includes database sys data the it will be easily full?
please advise...
Technology News @ www.JassimRahma.com
|
|
|
|
|
|
|
Did you notice that is not the Express edition? But in either case the documentation provides the information you are looking for.
Veni, vidi, abiit domum
|
|
|
|
|
it is Express Edition.
Oracle Database Express Edition at the top and it's FREE and limited to 11 GB..!
It's confusing now..!
Technology News @ www.JassimRahma.com
|
|
|
|
|
From version 11g2 it's 11GB, before that it's 4GB.
|
|
|
|
|
|
If you go to the next page[^] they specify it as 11GB of user data. (emphasis mine)
|
|
|
|