General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Hi Cetin,
Yes, this table can be huge, It has come close to the 2GB limit in vfp. I will have more information hopefully late this week as I start working with program and data.
>>Hi All,
>>
>>We are currently going through OLE db from VFP to SQL Server, and we create at a temporary table, insert lots of records into it, then running queries against the temporary table and other tables. The queries can be different every time, not static queries. This takes a lot of time for building the temporary table (30 - 45 mins).
>>
>>I think this can be done be done through SP, but we keep reading that as soon as you leave the SP, the temporary table is closed.
>>
>>Hope this is enough info.
>>
>>Any ideas?
>>
>>TIA
>>Beth
>
>If you create the temptable outside SP it wouldn't be closed. I don't know how SP would help you there. How many records are you inserting into temp table on the average? 30-45mins doesn't sound to be a reasonable timing. It may be with very huge tables but it may also be due to a wrong way of inserting records. I mean you can insert 10 records in 10 seconds or subsecond depending on how you do that.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only