You don't need to store it in the database to use sql server indexing you can mix and match database and file index searches with sql server.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 01 March 2002 12:29 To: CF-Talk Subject: RE: Uploading file directly into SQL database Yes, we want to be able to use the SQL server indexing. In the db I'm already storing a reference to the file, for when someone needs to download it. We're finding that Verity is way too slow when we have a mixture of several Verity database collections and a Verity file collection. When we output the results of a verity search, we need to be able to check that someone has access to the file (based on other db data), before it is presented to them in the search results. Doing this with a SQL index search, we can do all the 'access-checking' and search with one query. Currently searching one of our (optimised) verity database collections can take up to 7 secs, doing the same search with SQL indexing knocks this down to 0.3 sec. Alex -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 01 March 2002 11:30 To: CF-Talk Subject: Re: Uploading file directly into SQL database > > I want to insert an uploaded file directly into a SQL database field. So > after the user has uploaded the file to our CF server, at some point later > (probably overnight), we can move this file to store it directly in the db. > > I have no idea how to make a start on this (the file's already uploaded to > the server), it's just the overnight routine I can't work out. > > Does anyone have any help for me???? > Alex, Do you really need to store the file in the database? You can store files in BLOBs in databases, but they aren't really made for that kind of thing. If you want to send the file out to someone some how, you'll need to extract it from the database, write it to the server and then send it out to the user. Why not just leave the file on the server in the first place and just store a reference to it in the database? What is it you're really trying to do? Regards Stephen ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
